mysql while 语法错误_mysql 语法错误

最新推荐文章于 2024-07-28 03:31:40 发布

Beta vulgaris

最新推荐文章于 2024-07-28 03:31:40 发布

阅读量486

点赞数

CC 4.0 BY-SA版权

文章标签： mysql while 语法错误

本文链接：https://blog.youkuaiyun.com/weixin_29151301/article/details/113436049

本文探讨了一个具体的MySQL存储过程创建案例中的语法错误，并给出了修正后的正确示例。文章详细分析了如何定义一个递增插入整数到表中的过程，并解决了因语法不规范导致的错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql>delimiter//mysql>CREATEPROCEDUREp14()->BEGIN->DECLARElineINT;->SETline=0;->WHILEline<73059DO->deletefromtest1wherecheck_out_id=(selectidfromidorderbyidlimit`line`,1...

mysql> delimiter //

mysql> CREATE PROCEDURE p14()

-> BEGIN

-> DECLARE line INT;

-> SET line=0;

-> WHILE line<73059 DO

-> delete from test1 where check_out_id=(select id from id order by id limit `line`,1);

-> SET line=line+1;

-> END WHILE;

-> END //

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 '`line`,1);

SET line=line+1;

END WHILE;

END' at line 6

mysql> drop procedure if exists p14;

-> delimiter //

Query OK, 0 rows affected, 1 warning (0.00 sec)

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 'delimiter' at line 1