/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
DROP DATABASE IF EXISTS `click`;
CREATE DATABASE `click` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `click`;
DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) default NULL,
`gender` varchar(10) default NULL,
`birth` datetime default NULL,
`email` varchar(255) default NULL,
`tel` varchar(255) default NULL,
`job` varchar(100) default NULL,
`salary` float default NULL,
`education` varchar(50) default NULL,
`remark` varchar(500) default NULL,
`active` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `person` VALUES (1,'陈致远','男','1987-05-12','zhiyuan123@sina.com','13832374232','销售',4500,'本科','无',1);
INSERT INTO `person` VALUES (2,'周猩猩','男','2011-10-05','zhouxx@126.com','15800834804','经理',30000,'本科',NULL,NULL);
INSERT INTO `person` VALUES (3,'万甄嬛','男','2011-10-13','onezhenhuan@watermelon.com','15800834593','经理',100000,'本科',NULL,NULL);
INSERT INTO `person` VALUES (4,'周',NULL,NULL,NULL,NULL,'无',0,'本科',NULL,NULL);
INSERT INTO `person` VALUES (5,'蔡名义','男','2011-10-03','cai1211@sina.com','15023134564','经理',5000,'博士',NULL,NULL);
INSERT INTO `person` VALUES (6,'王勇飞','男','1987-10-07','wang1111@hotmail.com','15456123125','销售',5600,'研究生',NULL,NULL);
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- 1
- 2
前往页