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.reindl@stripped
> <mailto:h.reindl@stripped>> 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/
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
