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 r
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 S
This doesn't work, it just sets the starting number, but it will still
increment by one unless you set the auto_increment_increment system variable,
but this affects all the tables in the DB and not just the particular table.
Thanks,
Jim McNeely
On Feb 23, 2011, at 10:26 AM, Carsten Pedersen w
I have read the manual, and you're right, the auto-increment_increment is a
system wide setting. I only want this on one table. I am in this instance
creating ID's for a separate system via HL7 for a Filemaker system, and
FileMaker is too lame and slow to actually spit out an ID in time for the
On 2/23/2011 12:41, Jim McNeely wrote:
Is there a way to set the auto-increment for a particular table to increase by
some number more than one, like maybe 10?
Thanks in advance,
Jim McNeely
The manual is your friend. Don't be afraid of it :)
http://dev.mysql.com/doc/refman/5.5/en/replicat
Den 23-02-2011 18:41, Jim McNeely skrev:
Is there a way to set the auto-increment for a particular table to increase by
some number more than one, like maybe 10?
Thanks in advance,
Jim McNeely
CREATE TABLE t (
...
) AUTO_INCREMENT=10;
/ Carsten
--
MySQL General Mailing List
For list archi
