MySQL General - Values of Auto Incremented Columns
Interview Question Database For Software Developers
|
|
| Values of Auto Incremented Columns | 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?
| | By: FYIcenter.com | | The value of user_id of the new record will be 2346. | | ID: 5 | Rank: 2001 | Votes: -2 | Views: 725 | Submitted: 20060901 |
1915
:-) | | 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... | | Submitted: 20060901 |
|
2001
:-) | | Values of Auto Incremented Columns | | Assuming that the structure of a table shows two columns like this:
--------+------------+------+-----+--------+---------------
Field | Type | Null | Key | Defa... | | Submitted: 20060901 |
|
Copyright © 2009 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view