Jump to content
Sign in to follow this  
beckiehawk

Georgia Sales Tax

Recommended Posts

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?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×