How can I write SQL for a table that shares the same name as a protected keyword in MySql? [duplicate]

by

Order is a reserved word. Don’t use reserved words as table or field names; or wrap it in the escape characters such as ` for mysql. Personally I just avoid using them as they generally cause more headache than they are worth in the long run.

Example:

mysql_query("SELECT * FROM `order` WHERE orderID = 102;");

MORE INFO – you can get more info about reserved word here https://dev.mysql.com/doc/refman/5.5/en/keywords.html

More Related Contents:

  1. PHP DateTime supported formats
  2. Can I call a PHP function in a JavaScript click handler?
  3. How to create a chat program using php and mysqli for chatting [closed]
  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 ‘WHERE `id` [closed]
  5. Can I store images in MySQL [duplicate]
  6. MySQL – This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery
  7. Fixing broken UTF-8 encoding
  8. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  9. Are mysql_real_escape_string() and mysql_escape_string() sufficient for app security?
  10. Hiding true database object ID in url’s
  11. Replacing mysql_* functions with PDO and prepared statements
  12. How to insert an array into a single MySQL Prepared statement w/ PHP and PDO
  13. Laravel 5.4 field doesn’t have a default value
  14. Find Point in polygon PHP
  15. phpmyadmin automatic logout time
  16. unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING error [duplicate]
  17. Setting a connect timeout with PDO
  18. mysql_connect(): No connection could be made because the target machine actively refused it
  19. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  20. PDO MySQL: Insert multiple rows in one query
  21. Outputting all PHP errors to database not error_log
  22. Join two tables with comma separated values
  23. Laravel nested relationships
  24. getting the value of an extra pivot table column laravel
  25. php sample script for pagination [closed]
  26. Remotely connecting to a MySQL database
  27. how to execute mysql command DELIMITER
  28. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  29. How to get a list of databases?
  30. PDO and MySQL ‘between’

Leave a Comment