我想写个对表进行插入的存储过程语句,不知为什么老是说我语法有错
语句如下:
BEGIN
#Routine body goes here...
insert into t1(num, value, str) values(value1, value2, value3);
END;
这个是在navicat下写的。value1,value2为int,value3为varchar。
错误如下:
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 ')
BEGIN
#Routine body goes here...
insert into t1(num, value, str) values(va' at line 1
语句如下:
BEGIN
#Routine body goes here...
insert into t1(num, value, str) values(value1, value2, value3);
END;
这个是在navicat下写的。value1,value2为int,value3为varchar。
错误如下:
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 ')
BEGIN
#Routine body goes here...
insert into t1(num, value, str) values(va' at line 1
这样应该就没有问题啦;
你先用value1, value2, value3 用具体的数据替代掉,然后再一个个换回来,看看是什么问题