Re: Automatic key

I think the field type is "integer unsigned" , isn't it ? Jayme. http://www.conex.com.br/jjeffman -----Mensagem Original----- De: Chris Aitken <chris@ideal.net.au> Para: Webmaster <webmaster@eq-adventures.com>; <php-db@lists.php.net> Enviada em: quinta-feira, 23 de novembro de 2000 02:36 Assunto: Re: [PHP-DB] Automatic key > At 11:25 PM 22/11/2000, you wrote: > >Hello everyone, > > > >Access has this nifty primary key that automatically increases itself > >when a new record is entered. Now I am working with MySQL and the > >documentation is kind of messy, does anybody knows if there is some kind > >of automatic key in MySQL? And if there isn't, could anyone suggest a > >piece of code to auto-generate a code that would make some sense? > > > When you create a table, you set the first field to be the following > > ALTER TABLE tname ADD fname VARCHAR(10) NOT NULL PRIMARY KEY AUTO_INCREMENT > > where tname is the name of your table, fname is the field you want to set > as the key. The rest basically tells it that the field cant be empty, is > the primary key and to increment the record automatically upon each new record. > > > > Hope this helps. > > > > Chris > > > -- > Chris Aitken - Webmaster/Database Designer - IDEAL Internet > email: chris@ideal.net.au phone: +61 2 4628 8888 fax: +61 2 4628 8890 > -------------------------------------------- > > Unix -- because a computer's a terrible thing to waste! > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >