I need a query, can't find it anywhere.

[Natedawg]

I need a query for adding a column to my table, an auto increment one, so I can keep track of how many items I have in my database. I think it\'s like, ADD COLUMN TO Message idno int AUTO_INCREMENT is that it?

[jmabbate]

The syntax is

 

ALTER TABLE table_name

ADD COLUMN column_name INT UNSIGNED NOT NULL AUTO_INCREMENT,

ADD INDEX (column_name);

 

You\'ll find an example in the MySQL manual, section 6.5.4 under ALTER TABLE.

 

Joe