表结构:
CREATE TABLE `ifguser` (
`userId` bigint(20) NOT NULL,
`userAreaId` bigint(20) DEFAULT NULL,
`userLoginId` varchar(30) CHARACTER SET utf8 NOT NULL,
`userLoginPass` varchar(34) CHARACTER SET utf8 DEFAULT NULL,
`userName` varchar(30) CHARACTER SET utf8 NOT NULL,
`userLocked` smallint(6) NOT NULL DEFAULT '0',
`userType` smallint(6) NOT NULL DEFAULT '0',
`userCertificateType` smallint(6) DEFAULT NULL,
`userCertificateNo` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
`userUnitName` varchar(70) CHARACTER SET utf8 DEFAULT NULL,
`userNation` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
`userNotes` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
`userBeginTime` datetime DEFAULT NULL,
`userEndTime` datetime DEFAULT NULL,
`userTermId` bigint(20) DEFAULT NULL,
`userState` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
`userCode` int(10) unsigned DEFAULT NULL,
`userBindType` smallint(6) DEFAULT NULL,
`userInOut` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (`userId`),
KEY `userTermId` (`userTermId`),
KEY `userAreaId` (`userAreaId`),
KEY `userLoginId` (`userLoginId`),
CONSTRAINT `Fk_ifguser_ifgtermarea` FOREIGN KEY (`userAreaId`) REFERENCES `ifg_terminal_area` (`termAreaId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;数据
INSERT INTO `ifguser` VALUES (341734681998592,NULL,'张鑫','E2B9820C622D8580102FF48E73D2295B','张鑫',1,0,111,'474745745747',NULL,NULL,NULL,'2012-04-20 15:36:44','2012-04-21 14:50:16',341734681994496,NULL,8,0,'2');
INSERT INTO `ifguser` VALUES (341734681999104,NULL,'张德清','E2B9820C622D8580102FF48E73D2295B','张德清',1,0,111,'44747474',NULL,NULL,NULL,'2012-04-20 15:52:30','2012-04-21 11:10:03',341734681982976,NULL,9,0,'2');
INSERT INTO `ifguser` VALUES (341734682000896,NULL,'王铱','E2B9820C622D8580102FF48E73D2295B','王铱',1,0,111,'4747474',NULL,NULL,NULL,'2012-04-20 16:13:54','2012-04-20 16:34:50',341734681984000,NULL,10,0,'2');
INSERT INTO `ifguser` VALUES (341734682002432,NULL,'张厚兵','E2B9820C622D8580102FF48E73D2295B','张厚兵',1,0,111,'474747456464',NULL,NULL,NULL,'2012-04-20 16:20:02','2012-04-20 17:06:09',341734681989888,NULL,11,0,'2');
INSERT INTO `ifguser` VALUES (341734682007808,NULL,'王铱','E2B9820C622D8580102FF48E73D2295B','王铱',1,0,111,'46464646',NULL,NULL,NULL,'2012-04-20 16:35:52','2012-04-21 08:01:38',341734681984000,NULL,12,0,'2');
INSERT INTO `ifguser` VALUES (341734682008576,NULL,'冯地全','E2B9820C622D8580102FF48E73D2295B','冯地全',0,0,111,'4646456456',NULL,NULL,NULL,'2012-04-20 16:38:58','2012-12-31 16:41:00',341734682000640,NULL,13,0,'1');
INSERT INTO `ifguser` VALUES (341734682009344,NULL,'向文仁','E2B9820C622D8580102FF48E73D2295B','向文仁',1,0,111,'4645646',NULL,NULL,NULL,'2012-04-20 16:46:51','2012-04-21 13:46:49',341734681983744,NULL,14,0,'2');
INSERT INTO `ifguser` VALUES (341734682009856,NULL,'张厚兵','E2B9820C622D8580102FF48E73D2295B','张厚兵',1,0,111,'464646',NULL,NULL,NULL,'2012-04-20 17:06:36','2012-04-20 17:10:01',341734681990144,NULL,15,0,'2');
INSERT INTO `ifguser` VALUES (341734682010368,NULL,'张厚兵','E2B9820C622D8580102FF48E73D2295B','张厚兵',1,0,111,'4646464',NULL,NULL,NULL,'2012-04-20 17:10:37','2012-04-21 13:46:38',341734681990144,NULL,16,0,'2');
INSERT INTO `ifguser` VALUES (341734682015744,NULL,'张晓','E2B9820C622D8580102FF48E73D2295B','张晓',0,0,111,'464646',NULL,NULL,NULL,'2012-04-20 18:51:16','2012-12-31 18:53:46',341734681992960,NULL,17,0,'1');
INSERT INTO `ifguser` VALUES (341734682023424,NULL,'陈泽军','E2B9820C622D8580102FF48E73D2295B','陈泽军',1,0,111,'464646',NULL,NULL,NULL,'2012-04-20 20:58:32','2012-04-21 13:41:28',341734681991168,NULL,18,0,'2');
INSERT INTO `ifguser` VALUES (341734682029824,NULL,'明存华','E2B9820C622D8580102FF48E73D2295B','明存华',1,0,111,'464646',NULL,NULL,NULL,'2012-04-20 21:22:59','2012-04-20 22:14:20',341734681966592,NULL,19,0,'2');
INSERT INTO `ifguser` VALUES (341734682031104,NULL,'王朝胜','E2B9820C622D8580102FF48E73D2295B','王朝胜',1,0,111,'464646',NULL,NULL,NULL,'2012-04-20 21:24:25','2012-04-21 08:01:21',341734681982720,NULL,20,0,'2');
INSERT INTO `ifguser` VALUES (341734682032128,NULL,'李贤芳','E2B9820C622D8580102FF48E73D2295B','李贤芳',1,0,111,'464646',NULL,NULL,NULL,'2012-04-20 21:25:47','2012-04-21 14:48:13',341734681987328,NULL,21,0,'2');
INSERT INTO `ifguser` VALUES (341734682039552,NULL,'张连芳','E2B9820C622D8580102FF48E73D2295B','张连芳',1,0,111,'464646',NULL,NULL,NULL,'2012-04-20 22:11:21','2012-04-21 11:47:32',341734681993472,NULL,22,0,'2');
INSERT INTO `ifguser` VALUES (341734682041600,NULL,'明存华','E2B9820C622D8580102FF48E73D2295B','明存华',1,0,111,'46464',NULL,NULL,NULL,'2012-04-20 22:15:38','2012-04-21 14:49:11',341734681987840,NULL,23,0,'2');
INSERT INTO `ifguser` VALUES (341734682042624,NULL,'石思竞','E2B9820C622D8580102FF48E73D2295B','石思竞',1,0,111,'646464',NULL,NULL,NULL,'2012-04-20 22:20:47','2012-04-21 13:46:22',341734681984512,NULL,24,0,'2');
求指教啊...
CREATE TABLE `ifguser` (
`userId` bigint(20) NOT NULL,
`userAreaId` bigint(20) DEFAULT NULL,
`userLoginId` varchar(30) CHARACTER SET utf8 NOT NULL,
`userLoginPass` varchar(34) CHARACTER SET utf8 DEFAULT NULL,
`userName` varchar(30) CHARACTER SET utf8 NOT NULL,
`userLocked` smallint(6) NOT NULL DEFAULT '0',
`userType` smallint(6) NOT NULL DEFAULT '0',
`userCertificateType` smallint(6) DEFAULT NULL,
`userCertificateNo` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
`userUnitName` varchar(70) CHARACTER SET utf8 DEFAULT NULL,
`userNation` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
`userNotes` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
`userBeginTime` datetime DEFAULT NULL,
`userEndTime` datetime DEFAULT NULL,
`userTermId` bigint(20) DEFAULT NULL,
`userState` varchar(6) CHARACTER SET utf8 DEFAULT NULL,
`userCode` int(10) unsigned DEFAULT NULL,
`userBindType` smallint(6) DEFAULT NULL,
`userInOut` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (`userId`),
KEY `userTermId` (`userTermId`),
KEY `userAreaId` (`userAreaId`),
KEY `userLoginId` (`userLoginId`),
CONSTRAINT `Fk_ifguser_ifgtermarea` FOREIGN KEY (`userAreaId`) REFERENCES `ifg_terminal_area` (`termAreaId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;数据
INSERT INTO `ifguser` VALUES (341734681998592,NULL,'张鑫','E2B9820C622D8580102FF48E73D2295B','张鑫',1,0,111,'474745745747',NULL,NULL,NULL,'2012-04-20 15:36:44','2012-04-21 14:50:16',341734681994496,NULL,8,0,'2');
INSERT INTO `ifguser` VALUES (341734681999104,NULL,'张德清','E2B9820C622D8580102FF48E73D2295B','张德清',1,0,111,'44747474',NULL,NULL,NULL,'2012-04-20 15:52:30','2012-04-21 11:10:03',341734681982976,NULL,9,0,'2');
INSERT INTO `ifguser` VALUES (341734682000896,NULL,'王铱','E2B9820C622D8580102FF48E73D2295B','王铱',1,0,111,'4747474',NULL,NULL,NULL,'2012-04-20 16:13:54','2012-04-20 16:34:50',341734681984000,NULL,10,0,'2');
INSERT INTO `ifguser` VALUES (341734682002432,NULL,'张厚兵','E2B9820C622D8580102FF48E73D2295B','张厚兵',1,0,111,'474747456464',NULL,NULL,NULL,'2012-04-20 16:20:02','2012-04-20 17:06:09',341734681989888,NULL,11,0,'2');
INSERT INTO `ifguser` VALUES (341734682007808,NULL,'王铱','E2B9820C622D8580102FF48E73D2295B','王铱',1,0,111,'46464646',NULL,NULL,NULL,'2012-04-20 16:35:52','2012-04-21 08:01:38',341734681984000,NULL,12,0,'2');
INSERT INTO `ifguser` VALUES (341734682008576,NULL,'冯地全','E2B9820C622D8580102FF48E73D2295B','冯地全',0,0,111,'4646456456',NULL,NULL,NULL,'2012-04-20 16:38:58','2012-12-31 16:41:00',341734682000640,NULL,13,0,'1');
INSERT INTO `ifguser` VALUES (341734682009344,NULL,'向文仁','E2B9820C622D8580102FF48E73D2295B','向文仁',1,0,111,'4645646',NULL,NULL,NULL,'2012-04-20 16:46:51','2012-04-21 13:46:49',341734681983744,NULL,14,0,'2');
INSERT INTO `ifguser` VALUES (341734682009856,NULL,'张厚兵','E2B9820C622D8580102FF48E73D2295B','张厚兵',1,0,111,'464646',NULL,NULL,NULL,'2012-04-20 17:06:36','2012-04-20 17:10:01',341734681990144,NULL,15,0,'2');
INSERT INTO `ifguser` VALUES (341734682010368,NULL,'张厚兵','E2B9820C622D8580102FF48E73D2295B','张厚兵',1,0,111,'4646464',NULL,NULL,NULL,'2012-04-20 17:10:37','2012-04-21 13:46:38',341734681990144,NULL,16,0,'2');
INSERT INTO `ifguser` VALUES (341734682015744,NULL,'张晓','E2B9820C622D8580102FF48E73D2295B','张晓',0,0,111,'464646',NULL,NULL,NULL,'2012-04-20 18:51:16','2012-12-31 18:53:46',341734681992960,NULL,17,0,'1');
INSERT INTO `ifguser` VALUES (341734682023424,NULL,'陈泽军','E2B9820C622D8580102FF48E73D2295B','陈泽军',1,0,111,'464646',NULL,NULL,NULL,'2012-04-20 20:58:32','2012-04-21 13:41:28',341734681991168,NULL,18,0,'2');
INSERT INTO `ifguser` VALUES (341734682029824,NULL,'明存华','E2B9820C622D8580102FF48E73D2295B','明存华',1,0,111,'464646',NULL,NULL,NULL,'2012-04-20 21:22:59','2012-04-20 22:14:20',341734681966592,NULL,19,0,'2');
INSERT INTO `ifguser` VALUES (341734682031104,NULL,'王朝胜','E2B9820C622D8580102FF48E73D2295B','王朝胜',1,0,111,'464646',NULL,NULL,NULL,'2012-04-20 21:24:25','2012-04-21 08:01:21',341734681982720,NULL,20,0,'2');
INSERT INTO `ifguser` VALUES (341734682032128,NULL,'李贤芳','E2B9820C622D8580102FF48E73D2295B','李贤芳',1,0,111,'464646',NULL,NULL,NULL,'2012-04-20 21:25:47','2012-04-21 14:48:13',341734681987328,NULL,21,0,'2');
INSERT INTO `ifguser` VALUES (341734682039552,NULL,'张连芳','E2B9820C622D8580102FF48E73D2295B','张连芳',1,0,111,'464646',NULL,NULL,NULL,'2012-04-20 22:11:21','2012-04-21 11:47:32',341734681993472,NULL,22,0,'2');
INSERT INTO `ifguser` VALUES (341734682041600,NULL,'明存华','E2B9820C622D8580102FF48E73D2295B','明存华',1,0,111,'46464',NULL,NULL,NULL,'2012-04-20 22:15:38','2012-04-21 14:49:11',341734681987840,NULL,23,0,'2');
INSERT INTO `ifguser` VALUES (341734682042624,NULL,'石思竞','E2B9820C622D8580102FF48E73D2295B','石思竞',1,0,111,'646464',NULL,NULL,NULL,'2012-04-20 22:20:47','2012-04-21 13:46:22',341734681984512,NULL,24,0,'2');
求指教啊...
解决方案 »
- mysql如何查看在不同时刻数据库表中数据的变换情况
- 我今天上传了个PHP程序到我的空间,出现下面错误,请大家帮忙解决下!!
- mysql联合主键插入数据异常
- mysql多条件排序 怎么写 谢谢
- set global event_scheduler = on; Mysql错误
- 求sql语句将一个字段。按指定字符分成几个字段
- 高分求一sql语句
- 请问mysql能否完成自动发邮件的功能呢?
- 如何在MySQL中查找某一字段的值包含给定字符串(不一定完全匹配)的记录。
- mysql的远程配置问题
- 诡异的问题,关于mysql数据库,mysql-nt.exe进程
- 大师帮帮看看Mysql怎么使用Oracle的DBlink
mysql删除语句有两种 一种是删除数据 一种是删除表之后在重建表
你自己在mysql手册中找下你是用的那种
Cannot delete or update a parent row: a foreign key constraint fails('isffg'.'isfg_flow_client_minute',CONSTRAINT 'isfg_flow_client_minute_ibfk_1' FOREIGN KEY ('fcmUserId') REFERENCES 'ifguser' ('userId'))
再删除记录
SET FOREIGN_KEY_CHECKS = 1;
delete from ifgUser
SET FOREIGN_KEY_CHECKS = 1;