Sign Up Login


  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 4353

What?s the difference between query_cache_type 1 and 2?

 1 7040

How can we repair a MySQL table?

Infosys,

2 6626

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

 5 32533

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

Accenture, Pioneer, TISL,

3 30245

How many values can the SET function of MySQL take?

Creative Informatics,

2 9351

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

SigmaTree,

2 6938

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

 2 4565

What is maximum size of a database in MySQL?

Bastioncoup, CIS, NM, V2 Solutions, Wipro,

13 40709

Give the syntax of Grant and Revoke commands?

 1 8633

Explain Normalization concept?

Inuva,

2 9748

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

 3 7513

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

 5 11825

How can increase the performance of MySQL select query?

RV Technologies, Span Systems,

3 11203

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 4365

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is meant by mysqli?

666

What is pragma serially_reusable and why is it used?

628

can you elaborate on blob and text in mysql? : Mysql dba

658

What is key in mysql?

662

What is offset limit?

698

How do I remove a user from mysql?

756

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

701

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

708

How do you insert a table?

665

Can foreign key have duplicate values?

670

What is view? How can you create and drop view in mysql?

659

How do I start mysql client?

696

Is mysql free for enterprise?

669

How to create and drop view in mysql?

680

How do you rename a table in mysql?

704

For More Un-Answered { MySQL } Questions Click Here