【原创】 linux-mysql p…_[mysql_stmt_error]: this command is not supported

drop PROCEDURE sp_test;

DELIMITER $$

CREATE PROCEDURE sp_test()

begin

    declare o longtext;

    declare t longtext;

    set @o_tr='';

    set @t_tr='';

    set @t = replace(substring(date(now()),1,7),'-','');

    set @tb1 = concat("CREATE TABLE IF NOT EXISTS `once", @t, "` (   `id` char(32) NOT NULL,   `station_id` int(11) DEFAULT NULL,   `artist_id` int(11) DEFAULT NULL,   `song_id` int(11) DEFAULT NULL,   `time` datetime DEFAULT NULL,   `pad_id` int(11) DEFAULT NULL,   PRIMARY KEY (`id`),   KEY `station_id` (`station_id`),   KEY `artist_id` (`artist_id`),   KEY `song_id` (`song_id`),   CONSTRAINT `once", @t, "_ibfk_1` FOREIGN KEY (`station_id`) REFERENCES `Station` (`iD`),   CONSTRAINT `once", @t, "_ibfk_2` FOREIGN KEY (`artist_id`) REFERENCES `Artists` (`ID`),   CONSTRAINT `once", @t, "_ibfk_3` FOREIGN KEY (`song_id`) REFERENCES `Songs` (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");

    PREPARE stmt from @tb1;

    EXECUTE stmt;

    set @tb2 = concat("CREATE TABLE IF NOT EXISTS `time", @t, "` (   `id` char(32) NOT NULL,   `station_id` int(11) DEFAULT NULL,   `artist_id` int(11) DEFAULT NULL,   `song_id` int(11) DEFAULT NULL,   `once_id` int(11) DEFAULT NULL,   `time` datetime DEFAULT NULL,   `itime` datetime NOT NULL,   PRIMARY KEY (`id`),   KEY `station_id` (`station_id`),   KEY `artist_id` (`artist_id`),   KEY `song_id` (`song_id`),   KEY `once_id` (`once_id`),   CONSTRAINT `time", @t, "_ibfk_1` FOREIGN KEY (`station_id`) REFERENCES `Station` (`ID`),   CONSTRAINT `time", @t, "_ibfk_2` FOREIGN KEY (`artist_id`) REFERENCES `Artists` (`ID`),   CONSTRAINT `time", @t, "_ibfk_3` FOREIGN KEY (`song_id`) REFERENCES `Songs` (`ID`),   CONSTRAINT `time", @t, "_ibfk_4` FOREIGN KEY (`once_id`) REFERENCES `once", @t, "` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");

    PREPARE stmt from @tb2;

    EXECUTE stmt;

    set @tr = concat('before_insert_once', @t);

    set @s = concat("SELECT TRIGGER_NAME INTO @o_tr FROM information_schema.triggers WHERE TRIGGER_SCHEMA = 'DB_Music' AND TRIGGER_NAME = '", @tr,"';");

    PREPARE stmt from @s;

    EXECUTE stmt;

    if length(@o_tr) =0 then

        set @dr_on = concat("DROP TRIGGER IF EXISTS ", @tr);

        set @tr_on = concat("CREATE TRIGGER before_insert_once", @t, "   BEFORE INSERT ON once", @t, "   FOR EACH ROW   SET NEW.`ID` = replace(uuid(),'-','');");

        select reverse(substr(reverse(trim(replace(group_concat(' (select * from ',table_name, ') union'),',',''))),6)) into o FROM information_schema.tables WHERE table_schema = 'DB_Music' and table_name like 'once2%';

        set @o = concat("create or replace view onces as",o);

        PREPARE stmt from @o;

        EXECUTE stmt;

    end if;

    set @tr = concat('before_insert_time', @t);

    set @s = concat("SELECT TRIGGER_NAME INTO @t_tr FROM information_schema.triggers WHERE TRIGGER_SCHEMA = 'DB_Music' AND TRIGGER_NAME = '", @tr,"';");

    PREPARE stmt from @s;

    EXECUTE stmt;

    if length(@t_tr) = 0 then

        set @dr_ti = concat("DROP TRIGGER IF EXISTS ", @tr);

        set @tr_ti = concat("CREATE TRIGGER before_insert_time", @t, "   BEFORE INSERT ON time", @t, "   FOR EACH ROW   SET NEW.`ID` = replace(uuid(),'-','');");

        select reverse(substr(reverse(trim(replace(group_concat(' (select * from ',table_name, ') union'),',',''))),6)) into t FROM information_schema.tables WHERE table_schema = 'DB_Music' and table_name like 'time2%';

        set @t = concat("create or replace view times as",t);

        PREPARE stmt from @t;

        EXECUTE stmt;

        select @dr_on as dr_on, @tr_on as tr_on, @dr_ti as dr_ti, @tr_ti as tr_ti;

    end if;

end$$

call sp_test();\g