MySQL Interview Questions
Questions Answers Views Company eMail

Write a query to create a database and a table?

11

How to determine the location of the data directory?

13

What is the purpose of -> in the mysql terminal?

16




What you can use regular expression for in mysql? Support your answer with an example?

9

How would concatenate strings in mysql?

9

What is difference between mysql_connect and mysql_pconnect?

15

what is the procedure to configure the application of mysql?

12

Where’s database data actually stored? Is there a way to see the files which are stored?

15




Write a query to stop mysql in unix

11

What does the file with the extension: frm, myd, and myi contain?

9

What are enums used for in mysql?

13

How database are managed?

11

When to use order by in delete statement?

15

Why to use char instead of varchar in the database?

16

How can you make a database as your current database?

11


Post New MySQL Questions






Un-Answered Questions { MySQL }

how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

2


What is the purpose of using a heap table?

7


Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

11


What are the security alerts while using mysql?

30


How do you determine the location of mysql data directory?

7






Explain csv tables.

14


How to make a copy values from one column to another in mysql?

11


How to return query output in html format?

13


What is the difference between truncate and delete in mysql?

28


what is constraints?

11


How to get the number of rows selected or affected by a sql statement?

12


What is ISAM?

33


How can we get the number of rows affected by query?

25


How can you change the password of a mysql user?

9


What is a result set object?

16