Error when inserting my own table on my command line message ERROR 1064 (42000): You have an error in your SQL syntax;
I have created all the tables in this video on my laptop.
I only have one problem with inserting data for the orders table. Can you please help me with this issue?
mysql> INSERT INTO orders (id, product_id, user_id, address_id, ordered_on, status, cost) VALUES (1, 14, 1, 2, DATE("now", "-4 days"), "shipped", 10.99);
ERROR 1064 (42000): 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 ' "-4 days"), "shipped", 10.99)' at line 1 mysql>