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

MySQL Interview Questions

Questions Answers Views Company eMail

How do you prevent MySQL from caching a query?

1 4850

What?s the difference between query_cache_type 1 and 2?

1 7560

How can we repair a MySQL table?

Infosys,

2 7441

What are the advantages of stored procedures, triggers, indexes?

5 33780

What is the maximum length of a table name, database name, and fieldname in MySQL?

Accenture, Pioneer, TISL,

3 31137

How many values can the SET function of MySQL take?

Creative Informatics,

2 10085

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

SigmaTree,

2 7561

How many tables will create when we create table, what are they?

2 5231

What is maximum size of a database in MySQL?

Bastioncoup, CIS, NM, V2 Solutions, Wipro,

13 43599

Give the syntax of Grant and Revoke commands?

1 9326

Explain Normalization concept?

Inuva,

2 10403

How can we find the number of rows in a table using MySQL?

3 8391

How many ways we can we find the current date using MySQL?

5 12938

How can increase the performance of MySQL select query?

RV Technologies, Span Systems,

3 12074

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 4938

Post New MySQL Questions

Un-Answered Questions { MySQL }

What can I do with mysql?

985

How to enter Characters as HEX Numbers?

1061

Do I need to pay for mysql?

954

Why to use char instead of varchar in the database?

1278

What are the differences between a primary key and foreign key?

1167

Is mariadb better than mysql?

1104

How do I edit a stored procedure in mysql?

976

How do I grant privileges to a user in mysql phpmyadmin?

1003

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

1187

How do I get a list of table names in mysql?

988

How to convert character strings to numeric values?

1178

How to connect html form to mysql database using php?

991

How can I connect mysql database?

944

What data structure does mysql use?

1072

What is pdo in php mysql?

993

For More Un-Answered { MySQL } Questions Click Here