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 4623

maximum size of a database in mysql?

2 4902

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

1 3468

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

3 5673

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

2 5023

what is mysql optimization in brief?

2368

What is the difference between CHAR and VARCHAR data types?

Ramco,

2 8891

Give the syntax of REVOKE commands?

1 4417

Give the syntax of GRANT commands?

3 6360

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

3 8882

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

4 8561

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 6477

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 5383

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

HCL,

5 11048

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

8 14282

Post New MySQL Questions

Un-Answered Questions { MySQL }

Write a program using the select statement, while loop.

916

What is a definer?

890

Write a command with which mysql table can be repaired

949

How to rename an existing column in a table?

1058

Explain % and _ inside like statement?

1020

Can you shard mysql?

925

What is full form of xampp?

1184

What is horizontally scalable?

988

using primary can we relate two table, with out foreign key?

2717

What is the purpose of using ifnull() function?

997

What is pragma autonomous_transaction?

879

What command is used to delete the data from the table without deleting the table structure?

984

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

890

What is difference between mongodb and mysql?

921

Which is better sqlite or mysql?

1047

For More Un-Answered { MySQL } Questions Click Here