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

MySQL Interview Questions

Questions Answers Views Company eMail

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

971

How many columns can you create for an index?

1003

What does "i_am_a_dummy flag" do in mysql?

999

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

1199

What is sqlyog?

1083

How many triggers are possible in mysql?

1014

Write a query to retrieve a hundred books starting from 20th.

1566

In which language mysql has been written?

1393

What is a trigger in mysql?

1096

What is the difference between database and table?

1054

What is the query to display top 20 rows?

1075

What is save point in mysql?

1005

What is the difference between heap table and temporary table?

1162

What are the advantages of myisam over innodb?

1026

How to change a password for an existing user via mysqladmin?

1028

Post New MySQL Questions

Un-Answered Questions { MySQL }

How to dump a table to a file with 'mysqldump'?

1092

How to display top 50 rows?

1120

Describe mysql transaction properties.

1074

Explain Access Control Lists.

1041

In which year mysql created?

1015

I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

1972

What is the use of procedure in mysql?

981

What is full text indexing in mysql?

1002

How do I stop a query in mysql workbench?

1017

all the queries used in sql

2714

Is sqlite faster than mysql?

995

What does the file with the extension: frm, myd, and myi contain?

990

What is the default port for MySQL Server?

1127

What is the difference between truncate and delete?

1274

What is mysql server?

1156

For More Un-Answered { MySQL } Questions Click Here