MySQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

MySQL Interview Questions

Questions Answers Views Company eMail

what is the advantage of stored procedures, triggers and indexing in mysql

1 4513

maximum size of a database in mysql?

2 4794

how many fields can be updated using set in a mysql query?

1 3394

how many table created when we create a table in mysql?

3 5504

how many ways we can get the current date in mysql?

2 4919

what is mysql optimization in brief?

2307

What is the difference between CHAR and VARCHAR data types?

Ramco,

2 8750

Give the syntax of REVOKE commands?

1 4300

Give the syntax of GRANT commands?

3 6205

How many ways we can we find the current date using MySQL?

3 8736

What is the maximum length of a table name, a database name, or a field name in MySQL?

4 8418

Query to select passwords from a table having a column "Password" Whose length is b/w 8 &15 and having 'A' as the first character in the password irrespective of case.

3 6322

Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters

3 5241

SELECT country,city FROM customers GROUP BY country ORDER BY city DESC

HCL,

5 10822

how we can find nth max salary from an employe table by using my sql?

8 13838

Post New MySQL Questions

Un-Answered Questions { MySQL }

How many ways we can retrieve the date in result set of mysql using php?

1057

What is limit in mysql?

830

What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

981

Which is best pdo or mysqli?

853

What is clob datatype?

844

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1082

What is general log in mysql?

919

How do you flush privileges?

916

what is the difference between gui testing and database testing? : Mysql dba

1020

What are the types of queries?

900

Why we use mysql workbench?

853

Explain about the architecture of MYSQL?

931

If we use sum function in mysql, does it return sum of that row or for that column?

936

Difference between CHAR and VARCHAR?

1028

Is Mysql query is case sensitive?

972

For More Un-Answered { MySQL } Questions Click Here