Thanks, Mark, for the syntax. I had actually played around enough to
figure it out already and got it to work the way that I wanted to. I
guess when I asked the question, I wasn't fully aware of what I was
wanting. The LAST_INSERT_ID wasn't a major issue. I ended up using the
following code:
Hi Jason,
For MyISAM tables only, you can manually set the auto
increment counter using the syntax:
ALTER TABLE table_name AUTO_INCREMENT = 1000
Keep in mind, however, that this does not change the
value of the LAST_INSERT_ID() since it still
represents the value last inserted. On a freshly
crea
I have a ticketing system that sets the ID of the ticket as the
LAST_INSERT_ID. By default, it was counting up from 0. I updated the
ID of the last ticket to reflect a different numbering scheme
(MM). I would like to automate this but I don't want to change
the ID of a current ticket. I
