Re: [PHP-DB] Automatic key From: JJeffman (jjeffmanweb <email protected>)
Date: 11/23/00

I think the field type is "integer unsigned" , isn't it ?

Jayme.

http://www.conex.com.br/jjeffman

-----Mensagem Original-----
De: Chris Aitken <chris <email protected>>
Para: Webmaster <webmaster <email protected>>; <php-db <email protected>>
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 <email protected> 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 <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>