
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')
create table book(number varchar(20) not null,--这个地方如果是数值,则最好用数值类型
name varchar(25),
author varchar(25),
price varchar(20) not null, --这个地方最好用数值类型
publisher varchar(25) --这个地方多了一个逗号
)
CREATE TABLE IF NOT EXISTS `runoob_tbl`(`id` INT UNSIGNED AUTO_INCREMENT,
`name` VARCHAR(10) NOT NULL,
`url` VARCHAR(40) NOT NULL,
`country` VARCHAR(10) NOT NULL,
PRIMARY KEY ( `id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8
错把中文的括号写进去了
欢迎分享,转载请注明来源:内存溢出
微信扫一扫
支付宝扫一扫
评论列表(0条)