navicat for mysql运行sql文件出现错误
sql文件如下:
/*
MySQL Data Transfer
Source Host: localhost
Source Database: db_jiuye
Target Host: localhost
Target Database: db_jiuye
Date: 2012-11-30 19:32:33
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_admin
-- ----------------------------
//管理员用户
//
CREATE TABLE `t_admin` (
`userId` int(11) NOT NULL,
`userName` varchar(55) default NULL,
`userPw` varchar(55) default NULL,
PRIMARY KEY (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_doc
-- ----------------------------
//附件
CREATE TABLE `t_doc` (
`id` int(11) NOT NULL,
`mingcheng` varchar(55) default NULL,
`fujian` varchar(55) default NULL,
`fujianYuanshiming` varchar(50) default NULL,
`del` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_gonggao
-- ----------------------------
//公告
CREATE TABLE `t_gonggao` (
`gonggao_id` int(11) NOT NULL,
`gonggao_title` varchar(50) default NULL,
`gonggao_content` varchar(4000) default NULL,
`gonggao_data` varchar(50) default NULL,
PRIMARY KEY (`gonggao_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_liuyan
-- ----------------------------
//留言板
CREATE TABLE `t_liuyan` (
`liuyan_id` int(11) NOT NULL,
`liuyan_title` varchar(66) default NULL,
`liuyan_content` varchar(4000) default NULL,
`liuyan_date` varchar(250) default NULL,
`liuyan_user` varchar(50) default NULL,
PRIMARY KEY (`liuyan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_news
-- ----------------------------
//新闻
CREATE TABLE `t_news` (
`news_id` int(11) NOT NULL,
`news_title` varchar(55) default NULL,
`news_content` text default NULL,
`news_date` varchar(50) default NULL,
PRIMARY KEY (`news_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_stu
-- ----------------------------
//个人用户帐号
CREATE TABLE `t_stu` (
`stu_id` int(11) NOT NULL,
`stu_xuehao` varchar(55) default NULL,
`stu_realname` varchar(55) default NULL,
`stu_sex` varchar(50) default NULL,
`stu_age` varchar(50) default NULL,
`login_name` varchar(50) default NULL,
`login_pw` varchar(50) default NULL,
`del` varchar(50) default NULL,
PRIMARY KEY (`stu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_toudijianli
-- ----------------------------
//个人用户投递简历
CREATE TABLE `t_toudijianli` (
`id` int(11) NOT NULL,
`stuId` int(11) default NULL,
`zhaopinId` int(11) default NULL,
`shijian` varchar(50) default NULL,
`fujian` varchar(55) default NULL,
`fujianYuanshiming` varchar(50) default NULL,
`del` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_user
-- ----------------------------
//企业帐号
CREATE TABLE `t_user` (
`user_id` int(11) NOT NULL,
`user_name` varchar(55) default NULL,
`user_pw` varchar(50) default NULL,
`user_realname` varchar(50) default NULL,
`user_address` varchar(50) default NULL,
`user_tel` varchar(50) default NULL,
`user_email` varchar(50) default NULL,
`user_qq` varchar(50) default NULL,
`
user_del` varchar(50) default NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_zhaopin
-- ----------------------------
//招聘信息
CREATE TABLE `t_zhaopin` (
`id` int(11) NOT NULL,
`zhiwei` varchar(55) default NULL,
`xuliyaoqiu` varchar(55) default NULL,
`daiyui` varchar(4000) default NULL,
`gongzuodidian` varchar(50) default NULL,
`gongzuojingyan` varchar(50) default NULL,
`youxiaoqi` varchar(50) default NULL,
`qitashuoming` varchar(50) default NULL,
`zhaopinType` varchar(50) default NULL,
`fabushijian` varchar(50) default NULL,
`userId` int(11) default NULL,
`del` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_zhaopinhui
-- ----------------------------
//招聘会信息
CREATE TABLE `t_zhaopinhui` (
`id` int(11) NOT NULL,
`mingcheng` varchar(55) default NULL,
`shijian` varchar(55) default NULL,
`didian` varchar(50) default NULL,
`del` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
错误如下:
[Err] 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 '/*
MySQL Data Transfer
Source Host: localhost
Source Database: db_jiuye
T' at line 1
[Err] /*
MySQL Data Transfer
Source Host: localhost
Source Database: db_jiuye
Target Host: localhost
Target Database: db_jiuye
Date: 2012-11-30 19:32:33
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_admin
-- ----------------------------
//管理员用户
//
CREATE TABLE `t_admin` (
`userId` int(11) NOT NULL,
`userName` varchar(55) default NULL,
`userPw` varchar(55) default NULL,
PRIMARY KEY (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_doc
-- ----------------------------
//附件
CREATE TABLE `t_doc` (
`id` int(11) NOT NULL,
`mingcheng` varchar(55) default NULL,
`fujian` varchar(55) default NULL,
`fujianYuanshiming` varchar(50) default NULL,
`del` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_gonggao
-- ----------------------------
//公告
CREATE TABLE `t_gonggao` (
`gonggao_id` int(11) NOT NULL,
`gonggao_title` varchar(50) default NULL,
`gonggao_content` varchar(4000) default NULL,
`gonggao_data` varchar(50) default NULL,
PRIMARY KEY (`gonggao_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_liuyan
-- ----------------------------
//留言板
CREATE TABLE `t_liuyan` (
`liuyan_id` int(11) NOT NULL,
`liuyan_title` varchar(66) default NULL,
`liuyan_content` varchar(4000) default NULL,
`liuyan_date` varchar(250) default NULL,
`liuyan_user` varchar(50) default NULL,
PRIMARY KEY (`liuyan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_news
-- ----------------------------
//新闻
CREATE TABLE `t_news` (
`news_id` int(11) NOT NULL,
`news_title` varchar(55) default NULL,
`news_content` text default NULL,
`news_date` varchar(50) default NULL,
PRIMARY KEY (`news_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_stu
-- ----------------------------
//个人用户帐号
CREATE TABLE `t_stu` (
`stu_id` int(11) NOT NULL,
`stu_xuehao` varchar(55) default NULL,
`stu_realname` varchar(55) default NULL,
`stu_sex` varchar(50) default NULL,
`stu_age` varchar(50) default NULL,
`login_name` varchar(50) default NULL,
`login_pw` varchar(50) default NULL,
`del` varchar(50) default NULL,
PRIMARY KEY (`stu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_toudijianli
-- ----------------------------
//个人用户投递简历
CREATE TABLE `t_toudijianli` (
`id` int(11) NOT NULL,
`stuId` int(11) default NULL,
`zhaopinId` int(11) default NULL,
`shijian` varchar(50) default NULL,
`fujian` varchar(55) default NULL,
`fujianYuanshiming` varchar(50) default NULL,
`del` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_user
-- ----------------------------
//企业帐号
CREATE TABLE `t_user` (
`user_id` int(11) NOT NULL,
`user_name` varchar(55) default NULL,
`user_pw` varchar(50) default NULL,
`user_realname` varchar(50) default NULL,
`user_address` varchar(50) default NULL,
`user_tel` varchar(50) default NULL,
`user_email` varchar(50) default NULL,
`user_qq` varchar(50) default NULL,
`
user_del` varchar(50) default NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_zhaopin
-- ----------------------------
//招聘信息
CREATE TABLE `t_zhaopin` (
`id` int(11) NOT NULL,
`zhiwei` varchar(55) default NULL,
`xuliyaoqiu` varchar(55) default NULL,
`daiyui` varchar(4000) default NULL,
`gongzuodidian` varchar(50) default NULL,
`gongzuojingyan` varchar(50) default NULL,
`youxiaoqi` varchar(50) d
[Msg] Finished - Unsuccessfully
--------------------------------------------------