CREATE PROCEDURE `system1`.`Compare` ()
BEGIN
declare data1_companyID varchar(50) ,data1_projectID varchar(50) ,data1_taskID varchar(50) ,data1_groupNo varchar(50) ,data1_FileName varchar(50) ,data1_input01 text ,data1_input02 text ,data1_input03 text ,data1_input04 text ,data1_input05 text ,data1_input06 text ,data1_input07 text ,data1_input08 text ,data1_input09 text ,data1_input10 text ,data1_input11 text ,data1_input12 text ,data1_input13 text ,data1_input14 text ,data1_input15 text ,data1_input16 text ,data1_input17 text ,data1_input18 text ,data1_input19 text ,data1_input20 text ,data1_input21 text ,data1_input22 text ,data1_input23 text ,data1_input24 text ,data1_input25 text ,data1_input26 text ,data1_input27 text ,data1_input28 text ,data1_input29 text ,data1_input30 text ,data1_UserID text
declare data2_companyID varchar(50) ,data2_projectID varchar(50) ,data2_taskID varchar(50) ,data2_groupNo varchar(50) ,data2_FileName varchar(50) ,data2_input01 text ,data2_input02 text ,data2_input03 text ,data2_input04 text ,data2_input05 text ,data2_input06 text ,data2_input07 text ,data2_input08 text ,data2_input09 text ,data2_input10 text ,data2_input11 text ,data2_input12 text ,data2_input13 text ,data2_input14 text ,data2_input15 text ,data2_input16 text ,data2_input17 text ,data2_input18 text ,data2_input19 text ,data2_input20 text ,data2_input21 text ,data2_input22 text ,data2_input23 text ,data2_input24 text ,data2_input25 text ,data2_input26 text ,data2_input27 text ,data2_input28 text ,data2_input29 text ,data2_input30 text ,data2_UserID text
declare canCheckFlag int(11)-----------------------------------错误信息---------------
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 'varchar(50) ,data1_projectID varchar(50) ,data1_taskID varchar(50) ,data1_groupN' at line 3
BEGIN
declare data1_companyID varchar(50) ,data1_projectID varchar(50) ,data1_taskID varchar(50) ,data1_groupNo varchar(50) ,data1_FileName varchar(50) ,data1_input01 text ,data1_input02 text ,data1_input03 text ,data1_input04 text ,data1_input05 text ,data1_input06 text ,data1_input07 text ,data1_input08 text ,data1_input09 text ,data1_input10 text ,data1_input11 text ,data1_input12 text ,data1_input13 text ,data1_input14 text ,data1_input15 text ,data1_input16 text ,data1_input17 text ,data1_input18 text ,data1_input19 text ,data1_input20 text ,data1_input21 text ,data1_input22 text ,data1_input23 text ,data1_input24 text ,data1_input25 text ,data1_input26 text ,data1_input27 text ,data1_input28 text ,data1_input29 text ,data1_input30 text ,data1_UserID text
declare data2_companyID varchar(50) ,data2_projectID varchar(50) ,data2_taskID varchar(50) ,data2_groupNo varchar(50) ,data2_FileName varchar(50) ,data2_input01 text ,data2_input02 text ,data2_input03 text ,data2_input04 text ,data2_input05 text ,data2_input06 text ,data2_input07 text ,data2_input08 text ,data2_input09 text ,data2_input10 text ,data2_input11 text ,data2_input12 text ,data2_input13 text ,data2_input14 text ,data2_input15 text ,data2_input16 text ,data2_input17 text ,data2_input18 text ,data2_input19 text ,data2_input20 text ,data2_input21 text ,data2_input22 text ,data2_input23 text ,data2_input24 text ,data2_input25 text ,data2_input26 text ,data2_input27 text ,data2_input28 text ,data2_input29 text ,data2_input30 text ,data2_UserID text
declare canCheckFlag int(11)-----------------------------------错误信息---------------
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 'varchar(50) ,data1_projectID varchar(50) ,data1_taskID varchar(50) ,data1_groupN' at line 3
解决方案 »
- (救急)mysql连接报错:ERROR 2013 (HY000): Lost connection to MySQL server during query
- key_buffer_size对分区表无效?
- 一条查询语句的讨论与疑问
- datetime类型数据查询问题
- mysql 奇怪问题
- MySQL初始化以及连接问题的总结
- 请大虾介绍比较好的导入工具
- 为何用fulltext搜索的结果为空?
- 请教ERROR:‘WinMySQLadmin.Ink’指向的驱动器或网络连接不可用
- 请问导入sql文件 mysql会先把数据库里面数据删除 然后在导入么?
- 如何用Navicate到处MySQL中创建表的SQL语句
- 关于MYSQL数据库的编码问题/求高手解答.
BEGIN
declare data1_companyID varchar(50) ,data1_projectID varchar(50) ,data1_taskID varchar(50) ,data1_groupNo varchar(50) ,data1_FileName varchar(50) ,data1_input01 text ,data1_input02 text ,data1_input03 text ,data1_input04 text ,data1_input05 text ,data1_input06 text ,data1_input07 text ,data1_input08 text ,data1_input09 text ,data1_input10 text ,data1_input11 text ,data1_input12 text ,data1_input13 text ,data1_input14 text ,data1_input15 text ,data1_input16 text ,data1_input17 text ,data1_input18 text ,data1_input19 text ,data1_input20 text ,data1_input21 text ,data1_input22 text ,data1_input23 text ,data1_input24 text ,data1_input25 text ,data1_input26 text ,data1_input27 text ,data1_input28 text ,data1_input29 text ,data1_input30 text ,data1_UserID text这句结束时的分号哪去了?
初学者可以多参考一下MYSQL帮助手册中的例子。MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?
http://community.csdn.net/Help/HelpCenter.htm#结帖