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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
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
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 :)
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
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
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
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