Databases Reporting with SQL Ordering, Limiting and Paging Results Limiting the Number of Results

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>

1 Answer

54,287 Points

Looks like you'll have to use the DATE_ADD function with MariaDB. There is also a DATE_SUB function for some reason. Both according to their description allow negative intervals.

You are also inserting the primary key id field when this field (at least in SQL playground ) is auto-incrementing,