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]
