1、update语句
错误：
update words w set w.Cid = 1 and w.Sid = 1
and w.WhiteRule = '院士|院长|工程院'
and w.Work_Status = 'wait'
and w.Last_Completed_Time = NOW()
and w.Is_Deleted = 0
and w.CreateTime = NOW()
where w.Sid NOT IN (0);
正确：
UPDATE words? w
set w.Cid = 1
, w.Sid = 1-- 需要变动的地方
, w.WhiteRule = '院士|院长|工程院'
, w.Work_Status = 'wait'
, w.Last_Completed_Time = SYSDATE()
, Is_Deleted = 0
, w.CreateTime = SYSDATE()
WHERE w.Sid is NULl;
2、存储过程中的格式
错误版：
DELIMITER $$
DROP PROCEDURE IF EXISTS insertSql $$
CREATE PROCEDURE insertSql()
BEGIN
declare indexSidOut int;-- 内层循环索引936次 -- 5486--6421
declare indexSidIn int;-- 外层循环索引31次
DECLARE fidC int;-- 院士id
DECLARE nameC VARCHAR(200); -- 院士姓名
SET indexSidIn = 1;
set indexSidOut = 5486;
REPEAT
??select fid INTO fidC , nameC INTO nameC from words where Id = indexSidOut;
????REPEAT-- 内层循环31次
?????insert into words(Sid , Fid , Word) VALUES(indexSidIn , fidC , nameC);
????? indexSidIn = indexSidIn + 1;
????UNTIL indexSidIn > 31;-- 此处不该有分号
??indexSidOut? = indexSidOut + 1;
UNTIL indexSidOut > 6421;-- 此处不该有分号
END REPEAT;
END $$
DELIMITER ;