Why should be SQL keywords, like CREATE TABLE and UPDATE, must be uppercase in WordPress?

Generally it does not (although it is probably a good thing to do and hopefully it is part of the coding standard.

That specific quote refers to the API which lets you add or change columns in the DB. For that to work wordpress needs to compare what the definition of the table in the DB to what the plugin asks it to create/change if needed, and without looking at the code, being specific about the case that is used just makes the “compare” code easier to write.

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  3. MySQL Error “Operand should contain 1 column”
  4. How to use MySQL DECIMAL?
  5. MySQL ERROR 1290 (HY000) –secure-file-priv option
  6. MySQL server startup error ‘The server quit without updating PID file’
  7. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  8. MySQL DROP all tables, ignoring foreign keys
  9. Duplicating a MySQL table, indices, and data
  10. mysql Foreign key constraint is incorrectly formed error
  11. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  12. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  13. mysql is not recognised as an internal or external command,operable program or batch
  14. SELECT * FROM multiple tables. MySQL
  15. mysql: SOURCE error 2?
  16. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  17. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  18. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  19. Data truncated for column?
  20. MySQL foreach loop
  21. MySQL IF NOT NULL, then display 1, else display 0
  22. MySQL date format DD/MM/YYYY select query?
  23. MySQL Calculate Percentage
  24. Repair all tables in one go
  25. Error: select command denied to user ‘‘@’‘ for table ‘‘
  26. Get the new record primary key ID from MySQL insert query?
  27. #1214 – The used table type doesn’t support FULLTEXT indexes
  28. How to change collation of database, table, column?
  29. Failed building wheel for mysql-python
  30. MySQL Error 1215: Cannot add foreign key constraint
  31. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  32. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  33. Remove Primary Key in MySQL
  34. How to use the keyword ‘references’ in MySQL?
  35. How to get the max of two values in MySQL?
  36. mysql: connection refused when trying to connect to localhost using remote IP
  37. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  38. Why are simple updates to wp_postmeta’s “_edit_lock” so slow?
  39. What are the recommended database permissions for WordPress?
  40. Complex meta query with 3 keys
  41. How can I find the source of slow queries in WordPress?
  42. How to log mysql errors from wordpress core?
  43. $wpdb and MySQL Create Trigger
  44. Fulltext search in posts sorted by relevancy
  45. wpdb Custom Meta Data with 2 conditions
  46. query to create woocommerce products from images
  47. Configure WordPress to connect to Mysql DB using SSH tunneling
  48. How to bulk delete all WordPress subscribers?
  49. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  50. Rewrite database urls
  51. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  52. Error while importing database
  53. Migrating from Existing MySQL Setup to WordPress
  54. How to split the a table in database?
  55. Can I restart MySQL engine when WordPress website is live?
  56. Why my wordpress loopback traffic while socket is setup?
  57. How do I join a $wpdb query with user meta using default value if not exist?
  58. mySQL statment count of post in each category and sub category
  59. Paypal Post IPN handeling nightmare
  60. Update or insert meta key value – On Duplicate key update
  61. Connect to MySQL using Windows Authentication
  62. Is there a page length limit?
  63. WordPress tables and aliases?
  64. What’s the sql for this condition?
  65. Create a form with custom autocomplete address field and CSV import values
  66. WordPress insert query is not working : Showing no Error
  67. How to get INSERT errors from $wpdb?
  68. Copy usermeta value where ID matches in the same table
  69. Export Yoast Keywords from MySQL/phpMyAdmin
  70. Same database; different WordPress
  71. Some Post Content Does Not Show Up In DB Search
  72. How can I write a formal sql query to get data from a custom table
  73. How can I view my site directly from WordPress dashboard?
  74. (WP List Table) How to sort by SKU and Custom Fields?
  75. Word Press and database from another server sync
  76. User set date and time from frontend doesn’t get stored into database
  77. get posts whether meta_key exists or not
  78. How to run SQL query from WordPress ‘WP Crontrol’ plugin
  79. How to bulk delete a certain part of all wordpress posts
  80. When I add metadata, metavalue length is added in to the value in some cases
  81. Changes not being reflected on new server
  82. update_option returns false in AJAX, how to debug?
  83. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  84. WordPress database error Duplicate entry for key ‘slug’
  85. How do I insert content of various MySQL fields in post?
  86. Select latest 2 articles, but only from given category
  87. CONCAT_WS in custom sql query
  88. Query does not filter duplicate _sku numbers
  89. Ordering topics by most replies in X days using MYSQL statement
  90. MySQL Select within WP Page template
  91. #1115 – Unknown character set: ‘utf8mb4’
  92. wp_postmeta – lot of meta fields
  93. Running WordPress from MySQL Cluster with HAPRoxy
  94. Delete posts with word count less than x number of words
  95. MySQL: get post_tag items that are tags (not SEO keywords)
  96. $wpdb->get_var returns 0
  97. cannot log in to the mysql server (wamp and wordpress)
  98. SQL command to export post_content from wp_posts using phpMyAdmin
  99. InnoDB: Error: log file ./ib_logfile0 is of different size
  100. Postgres equivalent to MySQL’s \G?
error code: 523