List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:February 23 2011 10:43pm
Subject:Re: auto_increment by more than 1
View as plain text  

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
Thread
auto_increment by more than 1Jim McNeely23 Feb
  • Re: auto_increment by more than 1Carsten Pedersen23 Feb
    • Re: auto_increment by more than 1Jim McNeely23 Feb
  • Re: auto_increment by more than 1MySQL)23 Feb
Re: auto_increment by more than 1Jim McNeely23 Feb
  • Re: auto_increment by more than 1Reindl Harald23 Feb
Re: auto_increment by more than 1Reindl Harald23 Feb