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 4615

maximum size of a database in mysql?

2 4896

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

1 3461

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

3 5661

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

2 5017

what is mysql optimization in brief?

2362

What is the difference between CHAR and VARCHAR data types?

Ramco,

2 8883

Give the syntax of REVOKE commands?

1 4412

Give the syntax of GRANT commands?

3 6349

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

3 8869

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

4 8553

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 6464

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 5375

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

HCL,

5 11036

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

8 14256

Post New MySQL Questions

Un-Answered Questions { MySQL }

can you tell the order of sql select statement? : Mysql dba

914

How to Set a root password if there is on root password.

1093

What is the use of mysql workbench?

1017

How to enter Characters as HEX Numbers?

1013

How to delete a database from mysql server.

1067

Why is mysql used?

938

What data type is money?

866

What is dbms in mysql?

971

Is mysql a nosql database?

1137

What is int mysql?

949

how you will Create a database on the mysql server with unix shell.

1047

Can mysql and mariadb coexist?

1094

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

2711

Is microsoft sql same as mysql?

989

What are the ways in which you can retrieve data in the result set of mysql using php?

989

For More Un-Answered { MySQL } Questions Click Here