我写了一个文件:create_procedure.sql
code:use inter;
drop procedure if exists proc_device_db_stroe;
create procedure proc_device_db_stroe(IN sn varchar(64),IN type int(4))
begin
set @sqlcmd = 'create table tb_test(id int(4));';
PREPARE stmt FROM @sqlcmd;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
end写了一个批处理命令:create.bat
code:
mysql -h localhost -uroot -p < create_procedure.sql
pause
当我双击执行create.bat文件时提示如下错误:
ERROR 1064 (42000) at line 4: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear '' at line 3
请问我这个存储过程哪有错误,但是为什么用MYSQL可视化工具执行create_procedure.sql文件中的代码没问题?
code:use inter;
drop procedure if exists proc_device_db_stroe;
create procedure proc_device_db_stroe(IN sn varchar(64),IN type int(4))
begin
set @sqlcmd = 'create table tb_test(id int(4));';
PREPARE stmt FROM @sqlcmd;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
end写了一个批处理命令:create.bat
code:
mysql -h localhost -uroot -p < create_procedure.sql
pause
当我双击执行create.bat文件时提示如下错误:
ERROR 1064 (42000) at line 4: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear '' at line 3
请问我这个存储过程哪有错误,但是为什么用MYSQL可视化工具执行create_procedure.sql文件中的代码没问题?
解决方案 »
- 数据库设计问题
- sql正则表达式替换
- 百分求解:如果备份这样格式的数据库-----------------------在线等.
- 如何把这样的数据插到另一个新的表里面
- 查询最近一周数据的问题
- 求一个简单的多表查询的sql,在此先多谢。
- 关于在WINDOWS下使用PostgreSql的相关问题,高分求解答~~
- 请问MySql在linux环境下有esql预编译工具吗?
- 求SQL一句(立等,急!!!!!!!!!!!!!!)
- mysql的临时文件突然增加几个G是什么情况?
- 一台机子启用多个mysql ,Fatal error: Please read "Security" section of the manual to find
- slow query is not to be trusted !
drop procedure if exists proc_device_db_stroe;
delimiter $$
create procedure proc_device_db_stroe(IN sn varchar(64),IN type int(4))
begin
set @sqlcmd = 'create table tb_test(id int(4));';
PREPARE stmt FROM @sqlcmd;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
end
$$
delimiter ;