How to transform a MSSQL CTE query to MySQL?

by

Unfortunately MySQL doesn’t support CTE (Common Table Expressions). This is long overdue IMO. Often, you can just use a subquery instead, but this particular CTE is recursive: it refers to itself inside the query. Recursive CTE’s are extremely useful for hierarchical data, but again: MySql doesn’t support them at all. You have to implement a stored procedure to get the same results.

A previous answer of mine should provide a good starting point:

Generating Depth based tree from Hierarchical Data in MySQL (no CTEs)

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. sql query to modify the selected value from database [closed]
  3. Calculate Average of the largest values in multiple columns
  4. SQL Print the name of all Employees together with the name of their supervisor
  5. How do you use the “WITH” clause in MySQL?
  6. Generating Depth based tree from Hierarchical Data in MySQL (no CTEs)
  7. Does SQL Server Offer Anything Like MySQL’s ON DUPLICATE KEY UPDATE
  8. MySQL “WITH” clause
  9. Storing JSON in database vs. having a new column for each key
  10. MySQL LIMIT clause equivalent for SQL SERVER
  11. How to export SQL Server database to MySQL? [duplicate]
  12. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  13. When to use SELECT … FOR UPDATE?
  14. Best practices for SQL varchar column length [closed]
  15. Relationship between catalog, schema, user, and database instance
  16. Import MySQL database into a SQL Server
  17. MySQL Aggregate Functions without GROUP BY clause
  18. mysql equivalent data types
  19. What resources exist for Database performance-tuning? [closed]
  20. How to write a (MySQL) “LIMIT” in SQL Server?
  21. sql group by versus distinct
  22. Syntax error: WITH is not valid input in this position
  23. How to import a SQL Server .bak file into MySQL?
  24. MySQL – Meaning of “PRIMARY KEY”, “UNIQUE KEY” and “KEY” when used together while creating a table
  25. Equivalent of MSSQL IDENTITY Column in MySQL
  26. Equivalent of MySQL ON DUPLICATE KEY UPDATE in Sql Server
  27. What are the max number of allowable parameters per database provider type?
  28. Why in SQL NULL can’t match with NULL?
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment