用navicat for mysql导入数据库提示错误,求大神指导 10
[Err]1050-Table't_admin'alreadyexists[Err]SETFOREIGN_KEY_CHECKS=0;-------------------...
[Err] 1050 - Table 't_admin' already exists
[Err] SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_admin
-- ----------------------------
CREATE TABLE `t_admin` (
`userId` int(11) NOT NULL AUTO_INCREMENT,
`userName` varchar(50) DEFAULT NULL,
`userPw` varchar(50) DEFAULT NULL,
PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- Table structure for t_timu
-- ----------------------------
CREATE TABLE `t_timu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(500) DEFAULT NULL,
`xuanxianga` varchar(500) DEFAULT NULL,
`xuanxiangb` varchar(500) DEFAULT NULL,
`xuanxiangc` varchar(500) DEFAULT NULL,
`xuanxiangd` varchar(500) DEFAULT NULL,
`daan` varchar(500) DEFAULT NULL,
`fenshu` int(11) DEFAULT NULL,
`del` varchar(50) DEFAULT NULL,
`kecheng` varchar(50) DEFAULT NULL,
`kecheng_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_user
-- ----------------------------
CREATE TABLE `t_user` (
`id` varchar(50) NOT NULL,
`loginname` varchar(50) DEFAULT NULL,
`loginpw` varchar(50) DEFAULT NULL,
`x
[Msg] Finished - Unsuccessfully
-------------------------------------------------- 展开
[Err] SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_admin
-- ----------------------------
CREATE TABLE `t_admin` (
`userId` int(11) NOT NULL AUTO_INCREMENT,
`userName` varchar(50) DEFAULT NULL,
`userPw` varchar(50) DEFAULT NULL,
PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- Table structure for t_timu
-- ----------------------------
CREATE TABLE `t_timu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(500) DEFAULT NULL,
`xuanxianga` varchar(500) DEFAULT NULL,
`xuanxiangb` varchar(500) DEFAULT NULL,
`xuanxiangc` varchar(500) DEFAULT NULL,
`xuanxiangd` varchar(500) DEFAULT NULL,
`daan` varchar(500) DEFAULT NULL,
`fenshu` int(11) DEFAULT NULL,
`del` varchar(50) DEFAULT NULL,
`kecheng` varchar(50) DEFAULT NULL,
`kecheng_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for t_user
-- ----------------------------
CREATE TABLE `t_user` (
`id` varchar(50) NOT NULL,
`loginname` varchar(50) DEFAULT NULL,
`loginpw` varchar(50) DEFAULT NULL,
`x
[Msg] Finished - Unsuccessfully
-------------------------------------------------- 展开
8个回答
展开全部
t_admin 表已经存在
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
Table 't_admin' already exists都告诉你了
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询
广告 您可能关注的内容 |