What are the types of index?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MySQL Interview Questions

what is the difference between gui testing and database testing? : Mysql dba

0 Answers  


What is schema in mysql?

0 Answers  


What is meant by mysql database?

1 Answers  


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

0 Answers  


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 Answers  






What are the different types of triggers in mysql?

0 Answers  


How to write date and time literals?

0 Answers  


If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?

0 Answers  


Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command

5 Answers   Amdocs, MediaSoft,


How can we store binary data in mysql?

2 Answers   HP,


What is mysql_pconnect?

0 Answers  


What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

0 Answers  


Categories