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, 7200👍, 0💬
Popular Posts:
How To Download and install PSP Evaluation? - PSP Tutorials - Fading Images to Background Colors wit...
How To Create an Add-to-Netvibes Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS News ...
What is Native Image Generator (Ngen.exe)? The Native Image Generator utility (Ngen.exe) allows you ...
How many types of validation controls are provided by ASP.NET ? There are six main types of validati...
If cookies are not enabled at browser end does form Authentication work? No, it does not work.