INSERT INTO ItemInfo (CourseID, OrganizationIdentifier,
ItemIdentifier,`Type`, Title, Launch, ParameterString, DataFromLMS,
TimeLimitAction, MinNormalizedMeasure,
AttemptAbsoluteDurationLimit,CompletionThreshold, `Next`, Previous,
`Exit`,ExitAll, Abandon, ResourceIdentifier, `Suspend`) VALUES ('Course-21',
'ORG-AAE040C6-5D31-FF80-7A74-C93346D3DE42', 'ITEM-C2D1FAF9-FF04-07BD-9A28-
CDC8DC6EC0B8', 'sco', 'Introduction', '/adl/CourseImports/Course-
21/Introduction/Introduction.html', '', '', '','', '', '', 'true', 'true',
'false', 'false', 'false', 'RES-65C9FBA6-5173-A9A8-C1A0-FE9EDFAB4788',
'false')
DROP PROCEDURE IF EXISTS P14delimiter //
CREATE PROCEDURE p14()
BEGIN
DECLARE line INT(10)
SET line=0
WHILE line<73059 DO
delete from test1 where check_out_id=(select id from id WHERE id >line LIMIT 1)
SET line=line+1
END WHILE
END//
这样子改一下就可以跑了
MYSQL语法错误:
1、更新表结构为
UPDATA tbl_name SET field_name2、正确的执行
UPDATE student SET studentName='哈哈' WHERE studentName=''欢迎分享,转载请注明来源:内存溢出
评论列表(0条)