Re: Mysql sequence help (OOT)
| From: | Zak Greant | Date: | Fri, 11 May 2001 04:08:04 +0000 |
| Subject: | Re: Mysql sequence help (OOT) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-52401@lists.php.net to get a copy of this message | ||
Use an auto_increment field.
ie.
create table foo (
id mediumint unsigned not null auto_increment primary key,
name char (16) not null,
...
)
--zak
----- Original Message -----
From: "Reuben D Budiardja" <reubendb@goshen.edu>
To: <php-general@lists.php.net>
Sent: Thursday, May 10, 2001 9:41 PM
Subject: [PHP] Mysql sequence help (OOT)
Hello,
Sorry for a litle bit out of topic.
But can anyone tell me how to create sequence in mysql?
For example, if I have table with column ID, NAME. I want ID to be
incremented by one (say starting from 100) everytime I insert a new row
to the table. How can I do that in mysql?
I'm only use to Oracle, and tried to find it in mysql.com, but has not
yet succed. And I'm a bit under time pressure.
Thanks for any help in advance.
Reuben D. Budiardja
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net