Am 23.02.2011 22:55, schrieb Singer X.J. Wang: > Yes, you can set it up so that it increases it by X only for that statement.. > eg. > > [other stuff] > set auto_increment_increment = X; > insert into that table you want > set auto_increment_increment = 1; > [other stuff] > > Now you have to remmeber doing that everywhere.. and everytime..
this was not the question, but hopefully your app does not inline-query in every second line, if so you should think about the apllication design it is generally senseless to change this value if you are not using master/master-replications where you do this globally > On Wed, Feb 23, 2011 at 16:42, Reindl Harald <h.rei...@thelounge.net > <mailto:h.rei...@thelounge.net>> wrote: > > Am 23.02.2011 22:29, schrieb Jim McNeely: > > I have read the manual, and you're right, the auto-increment_increment > is a system wide setting > > No, scope session means "set VAR=value" > > Command-Line Format --auto_increment_increment[=#] > Option-File Format auto_increment_increment > Option Sets Variable Yes, auto_increment_increment > Variable Name auto_increment_increment > Variable Scope Global, Session > > > -- > The best compliment you could give Pythian for our service is a referral. > -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/
signature.asc
Description: OpenPGP digital signature