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
Answers were Sorted based on User's Feedback
Answer / amita
in first condition even though u deleted all the records
from the table it takes the next no. of last deleted record.
suppose there is 2000 records in the table then it will take
2001.
and in second condition the ans is 2346
Is This Answer Correct ? | 3 Yes | 0 No |
What are mysql queries?
How do I restore a mysql database dump file in linux?
How do you say mysql?
How can we store binary data in mysql?
What is indexing in mysql?
How to extract a unit value from a date and time?
What does mysql flush hosts do?
What is the default port for mysql and how it can change?
What is mysql enterprise edition?
How to load data files into tables with 'mysqlimport'?
What is action query?
How do I kill a mysql connection?