I have a MySQL table with an unique autoincrement field (record_id). Normally, when I add a record, it starts at 1 and autoincrements. What I want now, is to be able to set the starting point to any number, i.e. I want to be able to start at let's say 20000.
The reason for this is that fields with record_id < 20000 are controlled by one application (i.e. I add/modify/delete the records with a record_id < 20000 from this application), and I want to add fields through another application, but without explicitely specifying the record_id.
How would I do this?
Ivan
-----
Iyengar Yoga Resources / GT Plugins
The reason for this is that fields with record_id < 20000 are controlled by one application (i.e. I add/modify/delete the records with a record_id < 20000 from this application), and I want to add fields through another application, but without explicitely specifying the record_id.
How would I do this?
Ivan
-----
Iyengar Yoga Resources / GT Plugins