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
how to repair a table in mysql?
Consider you have the following three tables which have to be linked together.
How do I start mysql in ubuntu?
What is heap table?
How do I save in mysql?
How do I create a new database in mysql?
How do I set user privileges in mysql?
How you will Show unique records.
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
Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba
What are the steps involved in query processing?
How do you start and stop MySQL on Windows?