Creating a table with an autoincrement primary key

Databases
InterBase (28)
MS-SQL (5)
mysql (36)
Oracle (1)

See also:

This article has not been rated yet. After reading, feel free to leave comments and rate it.

Question:

How can I create a table with an autoincrement field that is the primary key?

Answer:

Take a look at the following example. And it's auto_increment, not autoincrement.


	create table emails ( em_id int not null primary key auto_increment, em_to varchar(80), em_subject varchar(80), em_msg text);

Comments:

2008-06-25, 07:34:54

anonymous from South Africa

the auto_increment does not work

Email address (not necessary): Rate as	Hide my email when showing my comment. Please notify me once a day about new comments on this topic. Please provide a valid email address if you select this option.

It seems that you are from Washington, US . Info/ Feedback on this	Show city and country Show country only Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:
Add a picture: Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material.