Values of Auto Incremented Columns
Q
Assuming that the structure of a table shows two columns like this:
--------+------------+------+-----+--------+--------------- Field | Type | Null | Key | Default| Extra --------+------------+------+-----+--------+--------------- user_id | int(15) | | PRI | NULL | auto_increment email | varchar(80)| YES | | NULL | --------+------------+------+-----+--------+---------------
Assumming also that the value of user_id of the last record is 2345. What will be value of user_id if a new record is inserted after deleting all the rows in this table?
✍: FYIcenter.com
A
The value of user_id of the new record will be 2346.2006-09-01, 6230👍, 0💬