MySQL problem #1062

Rinnisaki · 2019-05-30T16:40:09.966Z

When I add these SQL it will cause this problem
How can I fix it?

INSERT INTO addon_account (name, label, shared) VALUES
(‘society_taxi’, ‘Taxi’, 1)
#1062 - Duplicate entry ‘society_taxi’ for key ‘PRIMARY’

and

INSERT INTO items (name, label, limit, rare, can_remove) VALUES
(‘cannabis’, ‘Cannabis’, 40, 0, 1),
(‘marijuana’, ‘Marijuana’, 14, 0, 1)

#1062 - Duplicate entry ‘cannabis’ for key ‘PRIMARY’

Pr0n3 · 2019-05-30T16:41:01.413Z

Its already in your table, remove those lines from the sql file

Rinnisaki · 2019-05-30T16:53:18.445Z

Thanks, I didn’t expect it to exist

Kingtrilogy_Green · 2020-09-23T03:10:10.032Z

i removed the lines but now im getting a error of 3 errors were found during analysis.

SQL query: Copy

INSERT INTO licenses (type, label) VALUES (‘weed_processing’, ‘Weed Processing License’) (‘chemicalslisence’, ‘Chemicals license’)

Beauflexx · 2020-10-01T18:27:24.352Z

cant figure this out either, and removing lines only brings more issues.
someone said try deleting the SQL from your database but i cant find it.

LangusMcgee · 2021-01-30T23:30:19.548Z

I tried a lot of things but nothing has worked.
if anyone knows how to fix it please say.

ImAvion · 2021-03-04T03:22:00.100Z

i need help

schwim · 2021-03-04T03:43:33.241Z

I like peanut butter.