#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near

Question

INSERT INTO `items` (`name`, `label`, `limit`, `rare`, `can_remove`) VALUES ('coke', 'Coca Leaves', 20, 0, 1);
INSERT INTO `items` (`name`, `label`, `limit`, `rare`, `can_remove`) VALUES ('coke_pooch', 'Bagged Cocaine', 10, 0, 1);

but i find this sql error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'I' at line 1

Answer 1

Try to escape name and limit, because these look to be the reserved words.

INSERT INTO items (`name`, label, `limit`, rare, can_remove) VALUES ('coke', 'Coca Leaves', 20, 0, 1); INSERT INTO items (`name`, label, `limit`, rare, can_remove) VALUES ('coke_pooch', 'Bagged Cocaine', 10, 0, 1);

This one works for me.