diggingdoggie
PPrisma
•Created by diggingdoggie on 5/1/2024 in #help-and-questions
Temporary table support?
Hi, I'm trying to create a temporary table. My sql works fine via mysql cmd line, but not via prisma client. Any idea what is wrong?
sql:
CREATE TEMPORARY TABLE TempA AS SELECT
ra.a,
ra.b
FROM
RA AS ra
The error is:
code: 'P2010',
www:dev: clientVersion: '5.12.1',
www:dev: meta: {
www:dev: code: '1105',
www:dev: message: "unknown error: syntax error at position 48 near 'AS'"
www:dev: }
2 replies