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 23238

what is the difrence between sql and pl/sql

Wipro,

21 28079

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

ABC,

3 9411

what is the main difference between myisam and innodb

Wipro,

2 6754

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

3 6085

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 7414

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

2 6078

How to see the database architecture in MySQL??

3 5904

how to delete duplicate rows in sql server 2005?

EWIT, Reliance,

2 5395

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

1 3232

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 7900

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?

2128

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

2227

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

1 4040

how to repair a table in mysql?

2 4547

Post New MySQL Questions

Un-Answered Questions { MySQL }

How many groups of data types?

984

How many rows we can insert in a mysql table?

963

What are the other commands to know the structure of a table using mysql commands except explain command?

1035

What is triggers?

959

Create table employee (eno int(2),ename varchar(10)) ?

1008

How can an index be declared in mysql?

948

What does blob mean in mysql?

967

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

932

What is difference between mysql and mysqli?

921

What is the difference between the LIKE and REGEXP operators?

1035

What is dump in mysql?

887

How to create a new view in mysql?

926

What is delimiter in mysql?

878

How do I know if mysql is running on windows?

1090

Can python connect to mysql?

1014

For More Un-Answered { MySQL } Questions Click Here