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, 6493👍, 0💬
Related Topics:
Math
Rachel opened her math book and found that the sum of the facing pages was 245. What pages did she open to? a. 122 and 123 b. 242 and 243 c. 16 and 17 d. 24 and 25 a. 2006-09-01, 7074👍, 0💬
Expression Evaluation
What is the value of this expression? +1-2*3/4 -0.5 2006-09-01, 6929👍, 0💬