MySQL ALTER:-Conditional

techie · 10-16-2007, 07:25 AM

I have a tool in mysql.There is a table with 3 columns project id ,issue id and handler id .Ihave to use ALTER acommand in a way that it has some dependency .
In the table i have to autoincrement issue id where project is is 3.
Just to autoincrement issueid the following commands work.
ALTER TABLE tablename AUTOINCREMENT=100.
but to use in the conditional way ,i don't know how to use.

chrism01 · 10-17-2007, 07:16 AM

I'm pretty sure that the autoincrement attribute only applies to a column, not a table, and it's either on or off. I don't think you can make it conditional, unless you've got v5.1 and use triggers... Strictly speaking that's not autoincrement anyway.