Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]

by

You need to escape reserved words like order with backticks

CREATE TABLE `order` ( ...

or better use another name instead.

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. How to select the nth row in a SQL database table?
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. Error Code: 2013. Lost connection to MySQL server during query
  5. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  6. Storing JSON in database vs. having a new column for each key
  7. How do I restore a dump file from mysqldump?
  8. MySQL Query to select data from last week?
  9. Using an Alias in SQL Calculations
  10. Can a table field contain a hyphen?
  11. Adding a leading zero to some values in column in MySQL
  12. View’s SELECT contains a subquery in the FROM clause
  13. Check for x consecutive days – given timestamps in database
  14. MySQL Insert Into from one Database in another
  15. How do I get the ID of multiple inserted rows in MySQL?
  16. How to insert data to MySQL with auto-incremented column(field)?
  17. Does mysql have the equivalent of Oracle’s “analytic functions”?
  18. Case statement in MySQL
  19. Replace Into Query Syntax
  20. Remove special characters from a database field
  21. Using reserved words in column names
  22. MySQL query, MAX() + GROUP BY
  23. MySQL – Replace Character in Columns
  24. FIND_IN_SET with multiple value [duplicate]
  25. Foreign key constraints: When to use ON UPDATE and ON DELETE
  26. What is the difference between SQL and MySQL? [closed]
  27. Selecting distinct 2 columns combination in mysql
  28. How to store a one to many relation in MySQL database?
  29. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;
  30. MySQL: Computed Column

Leave a Comment