MySQL Interview Questions
Questions Answers Views Company eMail

Write a query to create a database and a table?

76

How to determine the location of the data directory?

79

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

81




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

71

How would concatenate strings in mysql?

92

What is difference between mysql_connect and mysql_pconnect?

87

what is the procedure to configure the application of mysql?

83

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

86




Write a query to stop mysql in unix

72

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

68

What are enums used for in mysql?

75

How database are managed?

79

When to use order by in delete statement?

92

Why to use char instead of varchar in the database?

89

How can you make a database as your current database?

64


Post New MySQL Questions






Un-Answered Questions { MySQL }

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

105


Is mysql same as mariadb?

40


What is delimiter in mysql stored procedure?

36


How to declare variable in mysql trigger?

44


What is “i_am_a_dump” flag in mysql?

71






What are enums used for in mysql?

75


How do I start mysql server?

39


What is mysql default database?

37


How to use case expression?

66


What are date and time data types in mysql?

69


What are ddl statements in mysql?

79


Why is it called mysql?

45


Does mysql use tcp or udp?

41


What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

87


Write a query to find duplicate rows in table?

71