mysql: unrecognized statement type. (near WITH)

Question

I'm trying to create cte statement in phpmyadmin but phpmyadmin shows error on left 'unrecognized statement type. (near WITH)'. I really don't understand whats wrong with this code or MySql/phpmyadmin or any others configuration.

PHP Version 7.2.0. MySQL 5.0.12

click for snapshot

Answer 1

WITH keyword (Common Table Expressions) are not yet supported by phpmyadmin's sql parser yet can check it here.

Until that to use the same syntax use other alternatives tools like sequal pro for macos etc or sql command line itself.