MySQL Interview Questions
Questions Answers Views Company eMail

What is a storage engine?

9

What is a join? Explain the different types of mysql joins.

10

What is the purpose of using a heap table?

7




How can you change the password of a mysql user?

9

How can you calculate the sum of any column of a table?

9

What is meant by decimal (5,2)?

11

What is a trigger? How you can create a trigger in mysql?

9

What is the difference between unix timestamp and mysql timestamp?

9




How can you change the name of any existing table by using the sql statement?

9

What is the purpose of using ifnull() function?

13

How can you add and remove any column of a table?

11

How can you export the table as an xml file in mysql?

12

How can you create and drop view in mysql?

9

What is an index? How can an index be declared in mysql?

7

What are the differences between a primary key and foreign key?

6


Post New MySQL Questions






Un-Answered Questions { MySQL }

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

1887


How would you get the current date in mysql?

15


How to create a new view in mysql?

17


How to Set a root password if there is on root password.

32


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

11






How can you retrieve a particular number of records from a table?

10


How can we convert between Unix & MySQL timestamps?

31


How to set the time zone for MySQL to particular country time?

2176


How to get a list of columns in an existing table?

13


How to load data files into tables with 'mysqlimport'?

9


How to show all tables with 'mysql'?

15


What is “i_am_a_dump” flag in mysql?

10


What is 'mysqld'?

9


What is a trigger? How you can create a trigger in mysql?

9


What is the query to display top 20 rows?

29