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 4700

maximum size of a database in mysql?

2 4991

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

1 3526

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

3 5787

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

2 5138

what is mysql optimization in brief?

2415

What is the difference between CHAR and VARCHAR data types?

Ramco,

2 8991

Give the syntax of REVOKE commands?

1 4518

Give the syntax of GRANT commands?

3 6513

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

3 8981

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

4 8701

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 6606

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 5499

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

HCL,

5 11261

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

8 14558

Post New MySQL Questions

Un-Answered Questions { MySQL }

Is primary key auto increment?

991

Why are function needed?

1006

What are stored procedures and functions?

964

Can I use mysql for free?

950

What is trigger in mysql?

986

How do I show all mysql databases?

1023

What is database url for mysql?

1029

What is latest version of mysql?

1081

What is mysql installer?

1051

what is constraints? Also explain the different types of constraints?

1027

What is unsigned in mysql?

993

What is mysql in linux?

1119

What are the differences between char and nchar?

1192

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

1057

What is 'mysqladmin' in mysql?

1080

For More Un-Answered { MySQL } Questions Click Here