Add a "primary key" with auto_increment, like so: auto_notify_idnr bigint(21) default '0' not null primary key auto_increment
Same for the other table ;-) Aaron On Mon, 18 Nov 2002, Igor Olemskoi wrote: > how to create the following tables (CVS)? > > mysql> CREATE TABLE auto_notifications ( > -> auto_notify_idnr bigint(21) default '0' not null auto_increment, > -> user_idnr bigint(21) DEFAULT '0' NOT NULL, > -> notify_address VARCHAR(100) > -> ); > CREATE TABLE auto_replies ( > auto_reply_idnr bigint(21) DEFAULT '0' NOT NULL auto_increment, > ERROR 1075: Incorrect table definition; There can only be one auto column and > it must be defined as a key > mysql> CREATE TABLE auto_replies ( > -> auto_reply_idnr bigint(21) DEFAULT '0' NOT NULL auto_increment, > -> user_idnr bigint(21) DEFAULT '0' NOT NULL, > -> reply_body mediumtext > -> ); > ERROR 1075: Incorrect table definition; There can only be one auto column and > it must be defined as a key > > > -- > Best regards, > Igor mailto:[EMAIL PROTECTED] > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
