Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
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?
✍: FYIcenter.com
2006-09-01, 7282👍, 0💬
Popular Posts:
How To Dump the Contents of a Directory into an Array? - PHP Script Tips - Working with Directoris a...
What's the difference between J2SDK 1.5 and J2SDK 5.0? There is no difference, Sun Microsystems just...
How is the MVC design pattern used in Struts framework? In the MVS design pattern, there 3 component...
Advantages of a macro over a function? Macro gets to see the Compilation environment, so it can expa...
What is the difference between delegate and events? ã Actually events use delegates in bottom. But ...