MySQL Forums
Forum List  »  Triggers

Re: How to create trigger that generates an autoincrement number
Posted by: Mile Zajkovski
Date: November 16, 2005 09:49AM

I think the main usage of this is for creating auto_increment columns with "identity" and "seed" like in MSSQL Server.
For example, you might want a auto_increment column that starts with 1000 and increments its value by 10. Id's like 1010,1020,1030,1040 etc.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.