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.
>
