Mysql sequence help (OOT)
| From: | Reuben D Budiardja | Date: | Fri, 11 May 2001 03:41:22 +0000 |
| Subject: | Mysql sequence help (OOT) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-52398@lists.php.net to get a copy of this message | ||
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