MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE quote_items(quote_id INT, prod_id INT, rep_id INT, qty INT)
INSERT INTO quote_items ('quote_id', 'prod_id', 'rep_id', 'qty') VALUES (1, 2, 3, 4)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''quote_id', 'prod_id', 'rep_id', 'qty') VALUES (1, 2, 3, 4)' at line 1

INSERT INTO quote_items (quote_id, prod_id, rep_id, qty) VALUES (1, 2, 3, 4)