auto_incrementing by 4!

[JoSno]

Hello!

I wonder if anyone can tell me why when I enter data into a table using the autoincrement facility, the key is going up by four each time!

Strange!

Jo

 

[sleipnir214]

How are you inserting the data?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[JoSno]

well i have about seven columns with, say, column 1 on auto_increment. I'm then saying INSERT INTO table (col2, col3, col4...) VALUES (val2, val3, val4...); Notice I'm not putting anything in for the auto_increment column but it's values are 1, 5, 9...

Hope this helps

Jo

 

[sleipnir214]

I'm sorry I wasn't clear.

This is by hand in management software or from some program? I had a similar problem once (only by two's, though) in which my PHP code had a logic bug and was inserting the data twice each time.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[JoSno]

Oh I see, no this is through the C API and there is only one item being entered each time.

I am confised cos I've spoken to another guy here who says he's had the same thign on his software and he doesn't know why! he also said that his fluctuates on the same data set between incrementing in 1's and 4's!

Excellent!
Jo