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

MySQL Interview Questions

Questions Answers Views Company eMail

How MySQL is different from SQL?

HCL, IBM,

17 23294

what is the difrence between sql and pl/sql

Wipro,

21 28151

what is the difference between MyISAM and INNO DB in MySQL with the Advantage and disadvantage

ABC,

3 9416

what is the main difference between myisam and innodb

Wipro,

2 6758

which version of mysql can't support stored procedure??

3 6098

how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me

6 7429

I have two sql database at different PC.how can link b/w database and database tables.

2 6089

How to see the database architecture in MySQL??

3 5913

how to delete duplicate rows in sql server 2005?

EWIT, Reliance,

2 5404

Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr

1 3235

Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1

3 7907

In PHPmysql language how can we update our previous information.when update form open then we get our previous information in textbox,checkbox,selct,radio button.How can we show the information in checkbox,select menu,radio button which is available in database?

2135

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

2230

mazimum size of a database in mysql? when we create a table then how many tables actually created? write there name?

1 4043

how to repair a table in mysql?

2 4556

Post New MySQL Questions

Un-Answered Questions { MySQL }

Write a query to select all teams that won either 1, 3, 5 or 7 games.

1367

What is a table schema?

999

What are the difference between and myisam and innodb?

1027

What is difference between mysql mysqli and pdo?

944

How many TRIGGERS are allowed in MySql table?

1085

What is meant by mysqli?

904

What is difference between function and procedure in mysql?

966

What is mysql port?

1065

What data type is money?

873

How do you shutdown a mysql database?

1057

Explain the difference between procedure and function in mysql?

997

Why does mysql have so many connections?

898

how to connect a php script with the mysql database?

1053

What are the non-standard sql commands supported by 'mysql'?

998

Do I need python for mysql?

937

For More Un-Answered { MySQL } Questions Click Here