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

MySQL Interview Questions

Questions Answers Views Company eMail

What do you mean by % and _ in the LIKE statement?

982

How to enter Characters as HEX Numbers?

1005

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

934

How can I insert images into a Mysql database?

1046

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

1027

How many ways we can retrieve the date in result set of mysql using php?

1113

How to create a table?

986

How can we encrypt and decrypt a data presented in a table using mysql?

1045

What are the mysql database files stored in system ?

1053

How can we change the data type of a column of a table?

995

In how many ways we can retrieve data in the result set of mysql using php?

1121

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

1001

What are the advantages/disadvantages of mysql and php?

952

What do you need to connect php to mysql?

976

What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

1002

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is the use of mysql_close()?

973

How do I zip a file in mysql?

978

What is the storage engine for mysql?

956

How to change the database engine in mysql?

986

Is mysql frontend or backend?

898

What is sql vs mysql?

1005

How to analyze tables with 'mysqlcheck'?

1202

How to delete a database from mysql server.

1053

What is the size of mysql database?

933

How many primary keys can be there in a table?

981

What storage engines are used in MySQL?

1044

1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

1998

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?

1901

Explain the difference between mysql and mysql interfaces in php?

1081

Is sqlite faster than mysql?

934

For More Un-Answered { MySQL } Questions Click Here