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 4607

maximum size of a database in mysql?

2 4884

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

1 3451

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

3 5637

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

2 5003

what is mysql optimization in brief?

2357

What is the difference between CHAR and VARCHAR data types?

Ramco,

2 8866

Give the syntax of REVOKE commands?

1 4401

Give the syntax of GRANT commands?

3 6327

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

3 8859

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

4 8540

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 6448

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 5358

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

HCL,

5 11019

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

8 14199

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is trigger in mysql?

924

What is view in mysql?

965

How do I start mysql client?

960

Write a command to view mysql database table structure?

962

How many rows can mysql handle?

933

Which command is used to view the content of the table in mysql?

907

Which is faster mongodb or mysql?

890

What are stored procedures and functions?

897

Consider you have the following three tables which have to be linked together.

891

Where is mysql data stored?

880

What is cursor in mysql?

888

How do I truncate all tables in mysql?

976

How does limit work in mysql?

902

What is mysql enterprise edition?

902

I want to find out all databases starting with ‘test’, I have access to?

1149

For More Un-Answered { MySQL } Questions Click Here