Syntax error: WITH is not valid input in this position

by

WITH customers_in_usa AS is for now invalid MySQL code.
MySQL will support CTE’s in the future in MySQL version 8..

You could rewrite your SQL code, that should give the same results.

SELECT 
    customerName
  , state
FROM 
   customers 
WHERE
   country = 'USA'
 AND
   state="CA"
ORDER BY
   customerName

More Related Contents:

  1. MySQL “WITH” clause
  2. Are SELECT type queries the only type that can be nested?
  3. how to delete data from table A besides the customer service and director data in table B?
  4. Get records with max value for each group of grouped SQL results
  5. How to populate a table with a range of dates?
  6. MYSQL OR vs IN performance
  7. SELECTING with multiple WHERE conditions on same column
  8. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  9. How to find gaps in sequential numbering in mysql?
  10. MySQL: Invalid use of group function
  11. Combining UNION and LIMIT operations in MySQL query
  12. MySQL: View with Subquery in the FROM Clause Limitation
  13. MySql export schema without data
  14. MySQL combine two columns into one column
  15. How do I get the ID of multiple inserted rows in MySQL?
  16. MySQL: LIMIT by a percentage of the amount of records?
  17. limiting the rows to where the sum a column equals a certain value in MySQL
  18. MySql Transpose Row into Column and Column into Row [duplicate]
  19. MySQL multiple columns in IN clause
  20. MySQL Inner Join Query Multiple Tables
  21. How to select column names dynamically in mySQL
  22. sql join tables where 1 column has comma
  23. MySQL 1062 – Duplicate entry ‘0’ for key ‘PRIMARY’
  24. MySQL LEFT JOIN 3 tables
  25. FIND_IN_SET with multiple value [duplicate]
  26. MySql using correct syntax for the over clause
  27. How to select non “unique” rows
  28. Generate serial number in mysql query
  29. What are the benefits of only_full_group_by mode?
  30. mySQL SELECT upcoming birthdays

Leave a Comment