How many columns can you create for an index?


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

Post New Answer

More MySQL Interview Questions

Which mysql function is used to concatenate string?

1 Answers  


What is user in mysql?

0 Answers  


What is a longblob?

0 Answers  


What is difference between Sql server and MySql database? It may be silly question but i really dont know.

0 Answers  


What is pdo in mysql?

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  


How to show certain selected rows with the value "pcds".

0 Answers  


What is procedure in mysql?

0 Answers  


What is the phantom problem?

0 Answers  


What is mysql_connect?

0 Answers  


What causes mysql too many connections?

0 Answers  


How do I find my mysql username and password?

0 Answers  


Categories