Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

MySQL and auto_increment

Dec 2, 2002, 12:29 PM
Taranis
New User (1 post)
Dec 2, 2002, 12:29 PM
Post #1 of 2
Views: 4702
Shortcut
Quote Reply
MySQL and auto_increment
If I have a table with two columns several rows of data, how do I add an auto_increment field to the table?

Everything I have tried seems to give me errors.
Taranis
http://www.spittingllamas.com

"Formal Restrictions, contrary to what you might think,
free you up by allowing you to concentrate on purer ideas."
- Winter Sorbeck in Chip Kidd's The Cheese Monkeys
Dec 2, 2002, 1:33 PM
Paul
Veteran (19537 posts)
Dec 2, 2002, 1:33 PM
Post #2 of 2
Views: 4378
Shortcut
Quote Reply
Re: [Taranis] MySQL and auto_increment In reply to
Use mysqlman :)

Or in your create table syntax simply add auto_increment to the column you want to be auto-increment....

eg...

Code:
CREATE TABLE test_table (
autoinc_id int(10) unsigned DEFAULT '' NOT NULL auto_increment,
something int(10) unsigned DEFAULT '' NOT NULL ,
PRIMARY KEY (autoinc_id),
);

Last edited by:

Paul: Dec 2, 2002, 1:34 PM