麻烦大家看看这个Mysql 的存储过程错在哪？

2010-04-27 03:09:05 151 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

MySQL 存储过程原理理解以及存储过程的优点缺点 mysql> select curdate(),curtime(),now(); +------------+-----------+---------------------+ | curdate() | curtime() | now() | +------------+-----------+---------------------+ | 2020-10-16 | 08:54:58 | 2020-10-16 08:54:58 | +------------+-- 阅读详情

create procedure p1()
BEGIN
DECLARE v INT;
SET @uuid1 = UUID();
SET v=0;
WHILE v<2 DO
INSERT INTO t1(id1,@uuid1);
SET v= v+1;
END WHILE;
END;

而t1表结构是
create table t1(
id1 int(10) not null primary key AUTO_INCREMENT,
t1c1 varchar(100)）AUTO_INCREMENT = 1;

ERROR 1064 (42000): You have an error in your SQL syntax;

...全文

python机器人编程——用pytorch实现六轴机械臂的正向和逆向数值解算，及python算法解析前面对六轴（或多轴）机械臂进行了一些研究，特别是利用几何进行简化，实现逆解，来完成比较简单的搬用任务。然而，如果需要比较精确的操作任务，可能需要更加复杂的机械臂解算。其中比较复杂的是数值解算，这种解算往往涉及到比较复杂的机器人运动等原理知识，比较难以上手。但是，python的生态挺全面，已经有很多牛人实现了数值解法，但是去看他们的代码，还是觉得费劲。此外，随着深度神经网络的兴起，很多是用建立深度学习神经网络，去利用机械臂输入输出的大数据，训练机械臂的控制模型，这个上手也比较慢。阅读详情

grace8

MySQL 57,062 成员 56,759 内容

+ 关注 + 加入社区

切换为时间正序

grace8 2010-04-27

打赏
举报

你说的对，当时确实有这个的，我把它删除了。不管怎么说，你们是我学习的榜样！！

WWWWA 2010-04-27

打赏
举报

如果用分号，每一个赋值语句加SET，SET @uuid1 = UUID(); SET @uuid2 = UUID();
否则用逗号

ACMAIN_CHM 2010-04-27

打赏
举报

SET @uuid1 = UUID(); @uuid2 = UUID();@uuid3 = UUID(); @uuid4 = UUID();@uuid5 = UUID(); @uuid6 = UUID();@uuid7 = UUID(); @uuid8 = UUID();@uuid9 = UUID(); @uuid10 = UUID();@uuid11 = UUID();@uuid12 = UUID();@uuid13 = UUID();@uuid14 = UUID();@uuid15 = UUID();@uuid16 = UUID();@uuid17= UUID();@uuid18 = UUID();@uuid19 = UUID();@uuid20 = UUID();

分号改成逗号！

mysql> set @x=1,@y=2;
Query OK, 0 rows affected (0.00 sec)

grace8 2010-04-27

打赏
举报

呵呵，实际上这表有20个 varchar 类型的数据，我刚才简化了。现在是:
mysql> delimiter //
mysql> create procedure p1()
BEGIN
DECLARE v INT;
SET @uuid1 = UUID(); @uuid2 = UUID();@uuid3 = UUID(); @uuid4 = UUID();@uuid5 = UUID(); @uuid6 = UUID();@uuid7 = UUID(); @uuid8 = UUID();@uuid9 = UUID(); @uuid10 = UUID();@uuid11 = UUID();@uuid12 = UUID();@uuid13 = UUID();@uuid14 = UUID();@uuid15 = UUID();@uuid16 = UUID();@uuid17= UUID();@uuid18 = UUID();@uuid19 = UUID();@uuid20 = UUID();
SET v=0;
WHILE v<2 DO
INSERT INTO t1 values(id1,@uuid1,@uuid2,@uuid3,@uuid4,@uuid5,@uuid6,@uuid7,@uuid8,@uuid9,@uuid10,@uuid11,@uuid12,@uuid13,@uuid14,@uuid15,@uuid16,@uuid17,@uuid18,@uuid19,@uuid20);
SET v= v+1;
END WHILE;
END;
//

表结构如下：
mysql> create table t1(
-> id1 int(10) not null primary key AUTO_INCREMENT,
-> t1c1 varchar(100),
-> t1c2 varchar(100),
-> t1c3 varchar(100),
-> t1c4 varchar(100),
-> t1c5 varchar(100),
-> t1c6 varchar(100),
-> t1c7 varchar(100),
-> t1c8 varchar(100),
-> t1c9 varchar(100),
-> t1c10 varchar(100),
-> t1c11 varchar(100),
-> t1c12 varchar(100),
-> t1c13 varchar(100),
-> t1c14 varchar(100),
-> t1c15 varchar(100),
-> t1c16 varchar(100),
-> t1c17 varchar(100),
-> t1c18 varchar(100),
-> t1c19 varchar(100),
-> t1c20 varchar(100)
-> )AUTO_INCREMENT = 1;
Query OK, 0 rows affected (0.09 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 '@uuid
2 = UUID();@uuid3 = UUID(); @uuid4 = UUID();@uuid5 = UUID(); @uuid6 = UUID(' at
line 4

wwwwb 2010-04-27

打赏
举报

DELIMITER $$
DROP PROCEDURE IF EXISTS ddt$$
CREATE PROCEDURE `testa`.`ddt`()
BEGIN
DECLARE v INTEGER;
SET @uuid1=UUID();
SET v=0;
WHILE v<2 DO
INSERT INTO t1 VALUES(id1,@uuid1);
SET v= v+1;
END WHILE;
END$$

DELIMITER ;

ACMAIN_CHM 2010-04-27

打赏
举报

mysql> delimiter //

mysql>

mysql> create procedure p1()

    -> BEGIN

    -> DECLARE v INT;

    -> SET @uuid1 = UUID();

    -> SET v=0;

    -> WHILE v<2 DO

    ->  INSERT INTO t1 values (id1,@uuid1); -- ACMAIN values !

    -> SET v= v+1;

    -> END WHILE;

    -> END;

    -> //

Query OK, 0 rows affected (0.00 sec)



mysql> delimiter ;

mysql>

麻烦大家看看这个Mysql 的存储过程错在哪？

相关推荐