MySQL Interview Questions
Questions Answers Views Company eMail

How do we use % when performing a search query?

9

How do we delete a row in a table?

9

What is the difference between char and varchar?

8




What is the default port of mysql server?

8

What are the different column comparison operators in mysql?

9

Write a query to select all teams that won either 1, 3, 5 or 7 games.

8

What are the disadvantages of mysql?

10

Why do we use the mysql database server?

7




What are the technical specifications of mysql?

9

Write a query to count the number of rows of a table in mysql.

10

Write a query to display current date and time?

8

What is regexp?

8

How do you determine the location of mysql data directory?

7

What is the difference between float and double?

13

What is the usage of regular expressions in mysql?

9


Post New MySQL Questions






Un-Answered Questions { MySQL }

How to enter boolean values in sql statements?

10


How to returns the columns and column information pertaining to the designated table.

22


write a command to view the content of the table

12


How to escape special characters in sql statements?

12


What are the mysql database files stored in system ?

25






What is the usage of "i-am-a-dummy" flag in mysql?

11


What, if a table has one column defined as TIMESTAMP?

24


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

33


Write a query to fetch duplicate records from a table using mysql?

11


What are date and time intervals?

9


How to create a table index in mysql?

9


List some mysql advantages and disadvantages?

8


What is the default port number of mysql?

10


What are the method you will follow while sql installing

1362


What is a csv table?

10