The Ultimate Guide to High Availability with MariaDB

Comments - INSERT SELECT

11 months ago Florian Scherzberg
INSERT SELECT WITH CTE

When I try to use an INSERT SELECT statement with a Common Table Expression (CTE), I get a syntax error. I have not found out if CTE is not supported in INSERT SELECT statements. Does anyone know? Version 10.6

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.