mysql导入sql文件报错

问题描述

问 题

CREATE TABLE  `ak_ask` (

 `id` INT( 10 ) NOT NULL ,
 `problem` VARCHAR( 120 ) NOT NULL COMMENT  '问题',
 `name` VARCHAR( 30 ) NOT NULL COMMENT  '名字',
 `qq` INT( 12 ) UNSIGNED NOT NULL COMMENT  'qq号',
 `answer` TEXT COMMENT  '回答',
 `area` CHAR( 30 ) NOT NULL COMMENT  '地区',
 `atime` INT( 10 ) UNSIGNED NOT NULL COMMENT  '提交时间',
 `display` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT  '0' COMMENT
);

MySQL 返回：文档

#1064 - 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 ')' at line 16 

解决方案

#这么明显嘛
CREATE TABLE  `ak_ask` (

 `id` INT( 10 ) NOT NULL ,
 `problem` VARCHAR( 120 ) NOT NULL COMMENT  '问题',
 `name` VARCHAR( 30 ) NOT NULL COMMENT  '名字',
 `qq` INT( 12 ) UNSIGNED NOT NULL COMMENT  'qq号',
 `answer` TEXT COMMENT  '回答',
 `area` CHAR( 30 ) NOT NULL COMMENT  '地区',
 `atime` INT( 10 ) UNSIGNED NOT NULL COMMENT  '提交时间',
 `display` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT  '0' COMMENT '缺少注释内容'
);

这篇关于mysql导入sql文件报错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！