Special Characters in MySQL Table Name

by

Quote your ambiguous or “special” table names with a back tick:

INSERT INTO `e!` ...

Or better, don’t use special characters in table names to avoid such problems.

More Related Contents:

  1. Using LIMIT within GROUP BY to get N results per group?
  2. How to perform grouped ranking in MySQL
  3. Required to join 2 tables with their FKs in a 3rd table
  4. MySQL Trigger after update only if row has changed
  5. MySQL “WITH” clause
  6. Ordering by specific field value first
  7. MySQL “Group By” and “Order By”
  8. How to change the CHARACTER SET (and COLLATION) throughout a database?
  9. MySQL Query to select data from last week?
  10. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  11. How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?
  12. Are there disadvantages to using a generic varchar(255) for all text-based fields?
  13. SQL Query to show nearest date?
  14. How do I use properly CASE..WHEN in MySQL
  15. Getting all parent rows in one SQL query
  16. How to insert data to MySQL with auto-incremented column(field)?
  17. SQL unique varchar case sensitivity question
  18. How do I count columns of a table
  19. Difference between two table structure
  20. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  21. How to retrieve JSON data from MySQL?
  22. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  23. Why MySQL is giving error “Not allowed to return a result set from a function”?
  24. When to use a left outer join?
  25. MySQL 5.6 – DENSE_RANK like functionality without Order By
  26. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  27. What happens when I exhaust a bigint generated key? How to handle it?
  28. MySQL update statement to store ranking positions
  29. is there a length limit to group_concat or another reason why it would not work on a text field
  30. How to convert a varchar column type to date type without losing the dates

Leave a Comment