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 23793

what is the difrence between sql and pl/sql

Wipro,

21 28837

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

ABC,

3 9538

what is the main difference between myisam and innodb

Wipro,

2 6868

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

3 6197

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 7636

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

2 6188

How to see the database architecture in MySQL??

3 6030

how to delete duplicate rows in sql server 2005?

EWIT, Reliance,

2 5511

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

1 3295

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 8021

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?

2187

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

2266

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

1 4130

how to repair a table in mysql?

2 4640

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is the default port of mysql server?

1081

How do I create a stored procedure in mysql?

948

What are date and time data types in mysql?

1072

What is difference between mysqli and pdo?

1006

What is root password?

967

What are the types of database engines available in mysql?

1115

How to use 'mysql' to run sql statements?

1173

What is a mysql model?

1009

How we can get the current date in mysql?

1004

What is the maximum connection pool size?

1032

Is mysql deprecated?

966

Is mysql good for big data?

995

What is mysql default port number?

1059

How many triggers are possible in mysql?

1013

What is the use of mysql_fetch_array () function in php?

1009

For More Un-Answered { MySQL } Questions Click Here