MySQL Forums
Forum List  »  MySQL Administrator

[OS X] Create table error
Posted by: Whit Nelson
Date: August 16, 2005 02:14PM

Hello all -

I'm kinda new to this app (OS X mysql admin), and when I try to make a new table, I get this error:

Error executing SQL commands to create table. Incorrect table definition; There can only be one auto column and it must be defined as a key (error 1075).

I have tried selecting one column (id) as a primary key, but this does not solve the problem. Can anyone help? Thanks,

-- whit

Options: ReplyQuote


Subject
Written By
Posted
[OS X] Create table error
August 16, 2005 02:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.