What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?


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

Post New Answer

More MySQL Interview Questions

how to repair a table in mysql?

2 Answers  


Consider you have the following three tables which have to be linked together.

0 Answers  


How do I start mysql in ubuntu?

0 Answers  


What is heap table?

0 Answers  


How do I save in mysql?

0 Answers  






How do I create a new database in mysql?

0 Answers  


How do I set user privileges in mysql?

0 Answers  


How you will Show unique records.

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  


Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

0 Answers  


What are the steps involved in query processing?

0 Answers  


How do you start and stop MySQL on Windows?

3 Answers  


Categories