var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: autoincrement column is odd numbers
I was looking at one of my tables and I noticed that the autoincrement on the column was incrementing by two and not 1. So all of the row id numbers are odd (e.g. 1,3,5,7...).
Is there a config setting that I did to make this happen?
your script to insert new rows is actually executing the INSERT statement twice, but the duplicates are getting rejected, and you don't notice it because you have IGNORE as an option on the INSERT statement
So, how do I know that it's adding data twice? Can I look in a log to verify this?
try adding a few rows directly into mysql, i.e. outside of your app
Originally Posted by
if they increment by 1, then it's your app that has the problem
I just used AquaData Studio and inserted a new row and I still get the increment of 2.
[wild shot in the dark]Are there any triggers on the table?[/wild shot in the dark]
What does this return:
WHERE table_name = '<table_name>'
Here is what I get back
2 record(s) selected [Fetch MetaData: 2/ms] [Fetch Data: 0/ms]
[Executed: 1/5/10 8:58:53 AM PST ] [Execution: 4/ms]
MySQL :: MySQL 5.1 Reference Manual :: 126.96.36.199 Replication Master Options and Variables
i've never worked with master/slaves so i'm not familiar with this server setting, and i don't know if it can be applied to a single server
but at least this would explain the weird behaviour