List:General Discussion« Previous MessageNext Message »
From:Chris Date:July 13 1999 12:29pm
Subject:Re: Serial varchar(6) NOT NULL AUTO_INCREMENT
View as plain text  
I believe you have to use 'auto_increment' with an integer type, not
'varchar'.

--Chris

> i want that the Serial will grow automaticly by one each time i enter
> row, what is wrong ?
> (now it ask me for the serial)
> 
> CREATE TABLE zimmer (
>     -> Serial varchar(6) NOT NULL AUTO_INCREMENT,
>     -> PRIMARY KEY (Serial),
>     -> Breakfast ENUM("yes", "no") NOT NULL,
>     -> TitleA varchar(20) NOT NULL,
>     -> DescriptionA TINYTEXT NOT NULL,
>     -> LogoA varchar(15) NOT NULL);
> 
> --
> --------------------------
> Canaan Surfing Ltd.
> Internet Service Providers
> Ben-Nes Michael - Manager
> Tel: 972-6-6925757
> Fax: 972-6-6925858
> http://www.canaan.co.il
> --------------------------
> 
> 
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread7153@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
> 

Thread
Serial varchar(6) NOT NULL AUTO_INCREMENTBen-Nes Michael13 Jul
  • Re: Serial varchar(6) NOT NULL AUTO_INCREMENTA. Brandic13 Jul
    • Re: Serial varchar(6) NOT NULL AUTO_INCREMENTBen-Nes Michael13 Jul
      • Re: Serial varchar(6) NOT NULL AUTO_INCREMENTA. Brandic13 Jul
      • Re: Serial varchar(6) NOT NULL AUTO_INCREMENTTim Sailer13 Jul
    • Re: Serial varchar(6) NOT NULL AUTO_INCREMENTBen-Nes Michael13 Jul
  • Re: Serial varchar(6) NOT NULL AUTO_INCREMENTChris13 Jul
  • Re: Serial varchar(6) NOT NULL AUTO_INCREMENTPaul DuBois13 Jul