Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
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, 6995👍, 0💬
Popular Posts:
Which JavaScript file is referenced for validating the validators at the client side ? WebUIValidati...
What Are Data Pump Export and Import Modes? - Oracle DBA FAQ - Loading and Exporting Data Data pump ...
How To Create an Add-to-Netvibes Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS News ...
Why is it preferred to not use finalize for clean up? Problem with finalize is that garbage collecti...
How To Use Subqueries in the FROM clause? - MySQL FAQs - SQL SELECT Statements with JOIN and Subquer...