mysql> delimiter //
mysql> create procedure tt()
-> begin
-> declare id integer;
-> set id=1;
-> while(id<300)
-> do
-> set id=id+1;
-> set @ee= concat ("insert into url(urladdr) values('
-> end while;
-> prepare ee from @v_flag;
-> EXECUTE ee ;
-> DEALLOCATE PREPARE ee;
-> end;
-> //
Query OK, 0 rows affected (0.00 sec)mysql> delimiter ;
mysql> call tt();
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'NULL
at line 1
mysql>
mysql> create procedure tt()
-> begin
-> declare id integer;
-> set id=1;
-> while(id<300)
-> do
-> set id=id+1;
-> set @ee= concat ("insert into url(urladdr) values('
-> end while;
-> prepare ee from @v_flag;
-> EXECUTE ee ;
-> DEALLOCATE PREPARE ee;
-> end;
-> //
Query OK, 0 rows affected (0.00 sec)mysql> delimiter ;
mysql> call tt();
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'NULL
at line 1
mysql>
解决方案 »
- 急!!!怎么把excel表格的数据导入到mysql数据库中?
- 帮忙看看这SQL语句错在哪里?
- 关于这个需求有没有简单的查询方法?
- 请大家到QQ群:15771135,,一起讨论进步!!!!!!!!
- 怎样将远端的mysql数据库备份到本地,用C#实现,给个思路吧!
- mysql.jar找不到?我想用jdbc,用mysql做数据库,但why mysql.jar找不到?
- 提问 问题标签用户 服务器上的网站频繁出现连接数据库失败的提示,但是刷新一下又好了,什么问题?
- 大家说说更新Mysql到5.6如何进行数据库方面的测试
- ibatis 子查询取值
- MySQL 5.6.32压力测试(insert)问题
- 我想问下
- 一张表不设立主键会有什么坏处?
delimiter //
create procedure tt()
begin
declare id integer;
set id=1;
while(id<300)
do
set id=id+1;
set @ee= concat ("insert into url(urladdr) values('')","");
end while;
prepare ee from @v_flag;
EXECUTE ee ;
DEALLOCATE PREPARE ee;
end;
//
delimiter ;
create procedure tt()
begin
declare id integer;
set id=1;
while(id <300)
do
set id=id+1;
set @ee= concat("insert into url(urladdr) values('')"," ");
prepare v_flag from @ee; <--v_flag放在前面,后面是语句
EXECUTE v_flag;
DEALLOCATE PREPARE v_flag;
end while;
end;
//
create procedure tt()
begin
declare id integer;
set id=1;
while(id <300)
do
set id=id+1;
set @ee= concat("insert into url(urladdr) values('')"," ");
prepare v_flag from @ee;
EXECUTE v_flag;
DEALLOCATE PREPARE v_flag;
end while;
end;
//
OK 3Q