List:General Discussion« Previous MessageNext Message »
From:Quentin Bennett Date:October 9 2000 10:24pm
Subject:RE: Auto_increment
View as plain text  
ALTER TABLE topic ADD topicid NOT NULL AUTO_INCREMENT PRIMARY KEY;


> -----Original Message-----
> From:	Chris Abate [SMTP:cabate@stripped]
> Sent:	Tuesday, October 10, 2000 11:03 AM
> To:	mysql@stripped
> Subject:	Auto_increment
> 
> Whenever i try to add a column that is using the auto_incrment function is
> gives me the following error:
> 
> ERROR 1064: parse error near 'AUTO_INCREMENT' at line 1
> 
> Why is this?  I enter it into the table using:
> 
> mysql> alter table topic add topicid int NOT NULL PRIMARY KEY
> AUTO_INCREMENT;
> 
> And it happens all the time not just when I try to add it to a table that
> already exists.  It occurs also to tables I'm just starting.
> 
> Any help is appreciated,
> Chris
> cabate@stripped
> 
> 
> -- 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/documentation/manual.php" before
> posting. To request this thread, e-mail mysql-thread52795@stripped
> 
> To unsubscribe, send a message to:
>     <mysql-unsubscribe-quentin.bennett=trilogy.co.nz@stripped>
> 
> If you have a broken mail client that cannot send a message to
> the above address (Microsoft Outlook), you can use:
>     http://lists.mysql.com/php/unsubscribe.php
Thread
Auto_incrementChris Abate10 Oct
  • Re: Auto_incrementStephen Johnson10 Oct
  • RE: Auto_incrementDon Read10 Oct
RE: Auto_incrementQuentin Bennett10 Oct