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, 7200👍, 0💬