Re: [PHP-DB] Auto inc in MySQL

2003-07-09 Thread Leif K-Brooks
Stan Lemon wrote: Also, I believe in addition to AUTO_INCREMENT it has to be UNIQUE as well. Please correct me if I am wrong. No, just INDEX. UNIQUE will work fine, but I reccomend making it PRIMARY. -- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to de

Re: [PHP-DB] Auto inc in MySQL

2003-07-09 Thread Stan Lemon
You're not planning on using DB for the autoincrementing are you? Just stray mysql functions? Also, I believe in addition to AUTO_INCREMENT it has to be UNIQUE as well. Please correct me if I am wrong. - Stan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://ww

Re: [PHP-DB] Auto inc in MySQL

2003-07-09 Thread dpgirago
Tris, make the the field, id_number, an auto_increment field. [EMAIL PROTECTED] on 07/09/2003 07:44:34 AM To: [EMAIL PROTECTED] cc:(bcc: David P. Giragosian/MDACC) Subject: [PHP-DB] Auto inc in MySQL I know I'll get flamed for askign such a simple question, but here goes... I

RE: [PHP-DB] Auto inc in MySQL

2003-07-09 Thread Rich Hutchins
Tristan, It is a simple question and the answer be found very easily in the MySQL manual. All you need to do is to create a column in your table of type AUTO_INCREMENT. Then, when you insert a row into the table, you simply insert NULL as the value for the auto-incremented column and it will be au