Re: auto-increment more than one field

2013-05-14 Thread Jan Steinman
From: rounak jain rounak.m...@gmail.com I have a table which needs two fields with auto-increment. I don't know if you have such control over your installation, but you might consider the work-alike MariaDB, which I believe supports auto-increment on multiple fields, as well as a slew of

Re: auto-increment more than one field

2013-05-12 Thread Michael Dykman
refer to http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html On Sun, May 12, 2013 at 9:39 AM, rounak jain rounak.m...@gmail.com wrote: I have a table which needs two fields with auto-increment. I have the found the answer here: