use trigger for create table

as the title,does this db can do this? i want change my db from ORACLE to MariaDB,some problem appeared. and how to use sqlstring? in ORACLE use sql='%some sentences%'; and executed immediate, how it does in MariaDB? so my email:bhdbing@163.com,Thank you for your help!

Answer

No, it is not possible. Our syntax for "sql='%some sentences%'; and executed immediate" (which is called "dynamic SQL") would be

prepare sql from 'some sentences';
execute sql;

but in MariaDB dynamic SQL is not allowed in triggers.

Comments

Comments loading...
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.