MySQL Interview Questions
Questions Answers Views Company eMail

What is a storage engine?

69

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

69

What is the purpose of using a heap table?

67




How can you change the password of a mysql user?

67

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

63

What is meant by decimal (5,2)?

78

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

72

What is the difference between unix timestamp and mysql timestamp?

66




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

81

What is the purpose of using ifnull() function?

67

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

84

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

70

How can you create and drop view in mysql?

80

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

69

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

56


Post New MySQL Questions






Un-Answered Questions { MySQL }

Does facebook still use mysql?

30


How many TRIGGERS are allowed in MySql table?

107


Explain the difference between procedure and function in mysql?

66


What is difference between schema and table?

30


Where is mysql data stored linux?

33






Can we use mysql and mysqli together?

43


How to represent ENUMs and SETs internally?

100


Why should I use mysql?

38


What is the purpose of mysql database?

32


How do I fix a crashed mysql database?

37


What is mysql data directory?

69


Why do we use the mysql database server?

63


Is sqlite faster than mysql?

41


Difference between CHAR and VARCHAR?

85


How to change a password for an existing user via mysqladmin?

90