CREATE TABLE `admin` (
`admin_id` int(4) unsigned NOT NULL auto_increment COMMENT '管理员编号',
`admin_name` varchar(40) NOT NULL COMMENT '管理员名称',
`admin_pwd` varchar(60) NOT NULL COMMENT '管理员密码',
`admin_class` varchar(20) NOT NULL COMMENT '管理员类别',
PRIMARY KEY (`admin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO 'admin' VALUES ('1', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '超级管理员');
INSERT INTO 'admin' VALUES ('8', 'nieh', 'f4e3102e629fa39520c48391fd4e49b2', '超级管理员');
INSERT INTO 'admin' VALUES ('9', 'xuy', 'c6da053e13965bcb210bd65a037c7897', '超级管理员');
INSERT INTO 'admin' VALUES ('10', 'wcl', '89d61033ba1d7b21c5a55c909c8bee92', '超级管理员');
INSERT INTO 'admin' VALUES ('11', 'qyan', '91b27853e91352e91349d688b112169a', '超级管理员');
`admin_id` int(4) unsigned NOT NULL auto_increment COMMENT '管理员编号',
`admin_name` varchar(40) NOT NULL COMMENT '管理员名称',
`admin_pwd` varchar(60) NOT NULL COMMENT '管理员密码',
`admin_class` varchar(20) NOT NULL COMMENT '管理员类别',
PRIMARY KEY (`admin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO 'admin' VALUES ('1', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '超级管理员');
INSERT INTO 'admin' VALUES ('8', 'nieh', 'f4e3102e629fa39520c48391fd4e49b2', '超级管理员');
INSERT INTO 'admin' VALUES ('9', 'xuy', 'c6da053e13965bcb210bd65a037c7897', '超级管理员');
INSERT INTO 'admin' VALUES ('10', 'wcl', '89d61033ba1d7b21c5a55c909c8bee92', '超级管理员');
INSERT INTO 'admin' VALUES ('11', 'qyan', '91b27853e91352e91349d688b112169a', '超级管理员');
看不到图片点这里
http://topic.csdn.net/u/20080419/12/eda20f50-0980-4700-8068-4960ac4e1200.html
CREATE TABLE `admin` (
`admin_id` int(4) unsigned NOT NULL auto_increment COMMENT '管理员编号',
`admin_name` varchar(40) NOT NULL COMMENT '管理员名称',
`admin_pwd` varchar(60) NOT NULL COMMENT '管理员密码',
`admin_class` varchar(20) NOT NULL COMMENT '管理员类别',
PRIMARY KEY (`admin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '超级管理员');
INSERT INTO `admin` VALUES ('8', 'nieh', 'f4e3102e629fa39520c48391fd4e49b2', '超级管理员');
INSERT INTO `admin` VALUES ('9', 'xuy', 'c6da053e13965bcb210bd65a037c7897', '超级管理员');
INSERT INTO `admin` VALUES ('10', 'wcl', '89d61033ba1d7b21c5a55c909c8bee92', '超级管理员');
INSERT INTO `admin` VALUES ('11', 'qyan', '91b27853e91352e91349d688b112169a', '超级管理员');