
14 Jun
2016
14 Jun
'16
10 p.m.
Hi Im trying to create a Procedure to create (or not) tables dynamically. Does Monet can do something like the following?? CREATE PROCEDURE(pdate date, tname varchar(10)) BEGIN SET TABLENAME = CONCAT(tname, '_', YEAR(pdate)*100+MONTH(pdate)); CREATE TABLE IF NOT EXIST TABLENAME; END Thanks in advance! Rgds