I am not able to run the
CREATE TABLE AS command in QGIS DB Manager (Win 10, QGIS 3.4.5-Madeira. I am getting the same error in QGIS 2.18 (Win 8).
Query execution error on CREATE TEMP VIEW _tview AS CREATE TABLE VV as SELECT 55 AS FF: 1 - near "CREATE": syntax error
Actually, I see even the following does not work on my Win 10.
CREATE TABLE CUSTOMERS( ID INT NOT NULL, AGE INT NOT NULL, SALARY DECIMAL (18, 2), PRIMARY KEY (ID) );
Am I missing something in syntax, or the DB manager is missing something?