1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category
MySQL Interview Questions
Questions Answers Views Company eMail

How do you prevent MySQL from caching a query?

 1 4041

What?s the difference between query_cache_type 1 and 2?

 1 6742

How can we repair a MySQL table?

Infosys,

2 6066

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

 5 31700

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

Accenture, Pioneer, TISL,

3 29637

How many values can the SET function of MySQL take?

Creative Informatics,

2 8744

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

SigmaTree,

2 6528

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

 2 4157

What is maximum size of a database in MySQL?

Bastioncoup, CIS, NM, V2 Solutions, Wipro,

13 38769

Give the syntax of Grant and Revoke commands?

 1 8287

Explain Normalization concept?

Inuva,

2 9299

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

 3 6993

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

 5 11189

How can increase the performance of MySQL select query?

RV Technologies, Span Systems,

3 10710

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 3947

Post New MySQL Questions

Un-Answered Questions { MySQL }

What are the functions in mysql?

491

What is mysql_connect?

501

What is back end and front end?

457

How do you use auto increment?

501

If we use sum function in mysql, does it return sum of that row or for that column?

523




How to find the unique values if the value in the column is repeated?

545

Is mysql a framework?

479

Explain triggers and stored procedures?

488

Is mysql same as mariadb?

471

What is the difference between truncate and delete?

589

Explain the different types of constraints?

512

How to delete the repeated records from a table?

495

How to create a new view in mysql?

523

How to drop an existing index in mysql?

546

How to return query output in html format?

520

For More Un-Answered { MySQL } Questions Click Here