SET @i=1;
WHILE @i<2 do
SELECT @i
SET @i = @i + 1;
end while请问下这个语句哪有问题了??
报的错误
错误码: 1064
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 'WHILE @i<2 do
SELECT @i
SET @i = @i + 1' at line 1Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000错误码: 1064
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 'end while' at line 1Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000哪位大哥麻烦写一个示例看看
WHILE @i<2 do
SELECT @i
SET @i = @i + 1;
end while请问下这个语句哪有问题了??
报的错误
错误码: 1064
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 'WHILE @i<2 do
SELECT @i
SET @i = @i + 1' at line 1Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000错误码: 1064
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 'end while' at line 1Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000哪位大哥麻烦写一个示例看看
解决方案 »
- 最近一周,发表分享最多的排名,前50名
- Starting MySQL.....ERROR!The server quit without updating PID file
- 打开phpmyadmin时出错。(我装的是easyPhp)
- PHP+phpMyAdmini总是安装不好哪位高手来指点一下
- Innodb 单张表的大小?
- 表分区, 但需要字段unique 的问题
- 请问怎样按自己要求自动增长?
- asp能连接MySql吗?
- 关于 mysql 数据库的备份问题
- 急!!!在线求解! MYSQL load data infile 失败!!!多谢!
- 求一本讲解数据库的工具书
- mysql存储过程参数可不可以带默认值
CREATE PROCEDURE TEST()
BEGIN
SET @i=1;
WHILE @i<2 do
SELECT @i
SET @i = @i + 1;
end while;
END$$DELIMITER ;