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