Zymic Webmaster Forums > Error With Sql

Help - Search - Members - Calendar

Full Version: Error With Sql

Zymic Webmaster Forums > Zymic Free Web Hosting > Databases & MySQL

roseinheaven

Aug 8 2008, 03:35 PM

Hello!
I want to modify a table of my database using this sentence:

CODE

ALTER TABLE name_of_the_table ADD ID INT NOT NULL AUTO_INCREMENT

but when I use this document, I have this error:

CODE

Incorrect table definition; there can be only one auto column and it must be defined as a key

What is wrong?

Thanks.

Alex

Aug 8 2008, 03:39 PM

It's saying you already have a column with auto_increment and is informing you than any such column must be a primary key.

What's the current table format? DESCRIBE or SHOW CREATE TABLE will give the details needed.

roseinheaven

Aug 9 2008, 11:01 AM

I don't know what is the table format. Where can I see it?
And I haven't got any column with auto_increment and the table have a primary key :S

Thanks.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.