ERROR 1336 (0A000): Dynamic SQL is not allowed in stored function or trigger
来源:互联网 发布:会php学java 编辑:程序博客网 时间:2024/06/11 13:19
- mysql> DELIMITER //
- mysql> CREATE PROCEDURE ps(IN table_name VARCHAR(200))
- -> BEGIN
- -> SET @newname = table_name;
- -> SET @s = CONCAT('create table ',@newname,'(resourceid varchar(200),',@newname,' varchar(200),time date)');
- -> PREPARE stmt FROM @s;
- -> EXECUTE stmt;
- -> DEALLOCATE PREPARE stmt;
- -> END
- -> //
- Query OK, 0 rows affected (0.00 sec)
- mysql> CREATE TABLE zs_resourcegroup(group_name VARCHAR(20));
- -> ;
- -> //
- Query OK, 0 rows affected (0.01 sec)
- mysql> DELIMITER //
- mysql> CREATE TRIGGER ts AFTER INSERT ON zs_resourcegroup
- -> FOR EACH ROW
- -> BEGIN
- -> CALL ps(new.group_name);
- -> END
- -> //
- Query OK, 0 rows affected (0.00 sec)
- mysql> insert into zs_resourcegroup select 'dba';
- -> //
- <span style="color:#ff0000;"><strong>ERROR 1336 (0A000): Dynamic SQL is not allowed in stored function or trigger</strong>
- </span>mysql>
- mysql>
- mysql> call ps("cui");
- -> //
- Query OK, 0 rows affected (0.01 sec)
- mysql> show tables;
- -> //
- +------------------+
- | Tables_in_test |
- +------------------+
- | cui |
- | t |
- | zs_resourcegroup |
- +------------------+
- 3 rows in set (0.00 sec)
上网查了一下,发现触发器中不支持动态sql,单独执行存储过程还是可以支持的。
0 0
- ERROR 1336 (0A000): Dynamic SQL is not allowed in stored function or trigger
- ERROR 1336 (0A000): Dynamic SQL is not allowed in stored function or trigger
- ERROR 1336 (0A000): Dynamic SQL is not allowed in stored function or trigger
- mysql触发器报错 1422 Explicit or implicit commit is not allowed in stored function or trigger.
- MySQL必知必会 ERROR 1415 (0A000): Not allowed to return a result set from a trigger
- Error:Content is not allowed in prolog.
- mysql -- error code [1442]; Can't update table 'table_name' in stored function/trigger because it is already used by statement w
- ERROR 1442 (HY000): Can\'t update table \'sign\' in stored function/trigger because it is already used by statement which invoke
- Error 1313: RETURN is only allowed in a FUNCTION SQL Statement
- SQL SERVER – Fix: Error Msg 128 The name is not permitted in this context. Only constants, expressions, or variables allowed her
- error: a function-definition is not allowed here before ‘{’ token
- Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/t
- mysql 触发器的问题 Can't update table 'tbl' in stored function/trigger because it is already used by state
- Can't update table 'psxt_user' in stored function/trigger because it is already used by statement wh
- mysql创建触发器错误提示:Can not update in stored function/trigger already used by statement invoked
- VS错误error C3872: '0x3000': this character is not allowed in an identifier
- VS错误error C3872: '0x3000': this character is not allowed in an identifier
- error C3872: '0x3000': this character is not allowed in an identifier 解决方法
- 谷歌考虑改版新闻服务:帮助新闻机构创收
- 分治的运用---最近点对
- Eclipse C++ (一)
- win2003 64bit上运行IIS6运行32bit的.NET4.0程序
- ubuntu如何知道软件安装到哪里了
- ERROR 1336 (0A000): Dynamic SQL is not allowed in stored function or trigger
- 经验总结53--java枚举
- mysql查询当前数据库中所有表
- spring4.1.6 学习之eclipse安装spring tool suite插件
- Run Loop详细说明
- 【UnityShader从零开始】
- 一点感悟:反馈的重要性
- WebView基本演绎法(2)
- iptables常用规则:屏蔽IP地址、禁用ping、协议设置、NAT与转发、负载平衡、自定义链