MYSQL建表为什么总是出现语法错误
CREATETABLEIFNOTEXISTS`runoob_tbl`(`id`INTUNSIGNEDAUTO_INCREMENT,`name`VARCHAR(10)NOT...
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;
第五行总是报错;求解。我实在不明白QAQ 展开
`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;
第五行总是报错;求解。我实在不明白QAQ 展开
1个回答
展开全部
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;
错把中文的括号写进去了
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询