Getting Error Trying to Create Table

From MySQL reference:

  • Permitted characters in unquoted identifiers:
    • ASCII:
      [0-9,a-z,A-Z$_] (basic Latin letters, digits 0-9, dollar, underscore)
    • Extended: U+0080 .. U+FFFF
  • Permitted characters in quoted
    identifiers include the full Unicode Basic Multilingual Plane (BMP),
    except U+0000:

    • ASCII: U+0001 .. U+007F
    • Extended: U+0080 ..
      U+FFFF
  • ASCII NUL (U+0000) and supplementary characters
    (U+10000 and higher) are not permitted in quoted or unquoted
    identifiers.
  • Identifiers may begin with a digit but unless quoted
    may not consist solely of digits.
  • Database, table, and column
    names cannot end with space characters.

So you have to remove - characters from the names of columns or quote these names.

It’s worth to mention that it would be a good idea to use the same naming conventions that WP is using. So table names should be lower-case and use _ as separator.

Related Posts:

  1. $wpdb to insert html form information
  2. List users with the most posts in the last 30 days
  3. Setting up foreign keys in phpMyAdmin?
  4. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  5. MySQL Error #1133 – Can’t find any matching row in the user table
  6. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  7. How to create a foreign key in phpmyadmin
  8. importing a CSV into phpmyadmin
  9. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  10. How do you properly prepare a %LIKE% SQL statement?
  11. $wpdb and MySQL Create Trigger
  12. wpdb->prepare function remove single quote for %s in SQL statment
  13. What specific database privileges does WordPress need?
  14. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  15. Alternative to mysql_real_escape_string
  16. Increment value (value = value+1) of $wpdb->update
  17. wpdb Custom Meta Data with 2 conditions
  18. wpdb prepare syntax
  19. SQL query not working in alphabetical post title/content search
  20. How to copy post titles to post slug in phpmyadmin
  21. MySQL LIKE not working
  22. How to do a MySQL dump from production site without using a search and replace script for local development?
  23. Proper way to work with wpdb to get user’s firstname
  24. How to check for empty and not a failure
  25. Database: Custom table: sprintf value for DateTime column
  26. Converting mysql to $wpdb
  27. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  28. WP_USE_EXT_MYSQL
  29. wpdb insert and boolean fields
  30. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  31. Join new table with SQL query
  32. writing inner join in wpdb
  33. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  34. Can’t find my wordpress DB in phpmyadmin
  35. How to split the a table in database?
  36. MySQL Rank & $wpdb
  37. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  38. How do I join a $wpdb query with user meta using default value if not exist?
  39. Backing up and restoring multiple sites efficiently
  40. How to translate this mySQL query to $wpdb query
  41. $wpdb select all meta for each post
  42. Proper usage of $wpdb->update()?
  43. WordPress(wpdb class) and mysql stored procedures
  44. Can’t run database query
  45. Using WPDB->Insert()
  46. Active DB queries in WordPress?
  47. How to stop $wpdb from prepending database name
  48. WordPress $wpdb get posts from category and sort by custom meta
  49. Setting up WordPress Locally on WAMP for a new site (with one already)
  50. How to get INSERT errors from $wpdb?
  51. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  52. Export Yoast Keywords from MySQL/phpMyAdmin
  53. Editing mysql tables/database with wordpress or other app/cms
  54. Understanding custom php that reads from WP MYSQL
  55. How to insert dash (-) into database using wpdb and new_to_publish hook?
  56. $wpdb->get_var multiple queries in one database check
  57. Insert two row in wordpress database
  58. WordPress $wpdb no result
  59. PHP variables in mysql query
  60. Export SQL query based on custom field?
  61. Mysql Server keeps crashing
  62. MySQL ‘duplicate entry’ error
  63. User set date and time from frontend doesn’t get stored into database
  64. Wpdb query with dynamic table name
  65. get posts whether meta_key exists or not
  66. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  67. How to bulk delete a certain part of all wordpress posts
  68. When I add metadata, metavalue length is added in to the value in some cases
  69. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  70. How to search usermeta table
  71. Find locations of all featured images of draft posts via SQL
  72. How to add virtual column in wpdb get_result statement
  73. SQL query to change custom field in WordPress database
  74. wpdb insert into point column in db
  75. An SQL query to find orphaned image attachments and their meta
  76. WPDB delivers wrong results from complex queries
  77. $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
  78. CONCAT_WS in custom sql query
  79. Geographical proximity query using post_meta
  80. MySQL Select within WP Page template
  81. Saving custom term value to the database in new table
  82. why is $wpdb->update() causing a DB error from within wp_set_password()
  83. $wpdb->get_var returns 0
  84. cannot log in to the mysql server (wamp and wordpress)
  85. SQL command to export post_content from wp_posts using phpMyAdmin
  86. Need SQL query to find&replace image URL
  87. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  88. How can I convert a string to a float in mysql?
  89. Is there a Profiler equivalent for MySql?
  90. How can I debug my database connection for unit testing?
  91. WordPress get pagination on wpdb get_results
  92. How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category
  93. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  94. Not getting ajax success response on insert/update row to database
  95. SQL query to bulk change short code in all posts
  96. How can I verify WordPress nonce from the following code?
  97. What is the cron doing?
  98. SQL error on restoring database
  99. MySQL database gives blank page (white screen of death)
  100. Global MySQL replacing of text patterns/matches