How to safely use reserved SQL names?

by

As already mentioned by Vishal Gajjar in the comments, you are using the reserved keyword desc for your column name, hence the error, it’s not bakes fault, it’s yours.

In order to be able to use such reserved words, the column name needs to be quoted properly, however CakePHP 3 doesn’t auto-quote by default anymore, as it’s an expensive operation.

If you insist on using reserved words, enable identifier quoting via the quoteIdentifiers option in your app.php config, or enable it manually using the autoQuoting() (enableAutoQuoting() as of CakePHP 3.4) method of the DB driver.

See also

More Related Contents:

  1. How to filter by conditions for associated models?
  2. How to limit contained associations per record/group?
  3. Cakephp-3.x: How to change the data type of a selected alias?
  4. How to create a `IN` clause in CakePHP query?
  5. SQL Server – error when creating stored procedure
  6. What do Clustered and Non-Clustered index actually mean?
  7. Regex pattern inside SQL Replace function?
  8. SQL Server Escape an Underscore
  9. How to create materialized views in SQL Server?
  10. Does a foreign key automatically create an index?
  11. Why use the INCLUDE clause when creating an index?
  12. How can I clear the SQL Server query cache?
  13. SQL Server Random Sort
  14. Add a new table column to specific ordinal position in Microsoft SQL Server
  15. Is there a way to simplify a NULL compare of 2 values
  16. How do I enable MSDTC on SQL Server?
  17. An attempt was made to access a socket in a way forbidden by its access permissions
  18. TSQL Try / Catch within Transaction or vice versa?
  19. What is the maximum number of characters that nvarchar(MAX) will hold?
  20. SQL Server history table – populate through SP or Trigger?
  21. cross apply xml query performs exponentially worse as xml document grows
  22. How to set monday as first day of week in SQL Server
  23. Format SQL in SQL Server Management Studio
  24. Split one column into multiple rows
  25. #DELETE viewing SQL Server table in Access
  26. Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)
  27. Grant Select on a view not base table when base table is in a different database
  28. SQL Server (localdb)\v11.0 explained
  29. SQL Server – join rows into comma separated list
  30. Which is quicker COALESCE OR ISNULL?

Leave a Comment