Georgia Sales Tax

[beckiehawk]

I downloaded the Georgia Sales Tax by county. It is based on the Ohio tax by county. When I try to import the 4 sql files, the first one, Georgia Zones, executes with no problem, but when I import the second one, Georgia Tax Rates, I get the following error

 

Error
SQL query:

INSERT INTO tax_rates
VALUES (

'',  '2',  '1',  '1',  '7.00',  'Atkinson County Tax (7.00%)', NULL , NOW( ) ,  'ATKINSON'
);

MySQL said: 

#1062 - Duplicate entry '0' for key 'PRIMARY' 

 

When I try to import the third one, Zones I get this error:

 

SQL query:

INSERT INTO zones
VALUES (

'', 223,  'GA',  'Georgia (Atkinson County)'
);

MySQL said: 

#1062 - Duplicate entry '0' for key 'PRIMARY' 

 

Then the last one, Zones to Georgia Zones, executes successfully.

 

I am not a an expert in SQL, so I don't know what to do about this. Can anyone tell me what I need to do here?

[multimixer]

Go to your phpMyAdmin and check if you have the "do not use auto-increment for zero values" checked

[beckiehawk]

Thank you so much... who woulda' thunk it.

 

That worked perfectly.