Re: [PHP-DB] Automatic key From: Chris Aitken (chris <email protected>)
Date: 11/22/00

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>