实例
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50724
Source Host : localhost:3306
Source Database : n2
Target Server Type : MYSQL
Target Server Version : 50724
File Encoding : 65001
Date: 2019-03-21 12:35:05
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `staff`
-- ----------------------------
DROP TABLE IF EXISTS `staff`;
CREATE TABLE `staff` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
`name` varchar(200) NOT NULL COMMENT 'name',
`age` char(10) DEFAULT NULL,
`phone` int(11) unsigned DEFAULT NULL,
`company` varchar(200) DEFAULT NULL,
`job` varchar(100) DEFAULT NULL,
`address` varchar(200) DEFAULT NULL,
`sal` int(10) DEFAULT NULL,
`edu` varchar(100) DEFAULT NULL,
`school` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of staff
-- ----------------------------
INSERT INTO `staff` VALUES ('1', '韦小宝', '23', '4294967295', '膳食房', '大内总管', '扬州', '5000', '无', '立春苑');
INSERT INTO `staff` VALUES ('2', '洪教主', '78', '4294967295', '神龙岛', '教主', '不明', '15000', '无', '无');
INSERT INTO `staff` VALUES ('3', '施琅', '43', '4294967295', '海军', '海军总管', '太晚', '20000', '无', '无');
INSERT INTO `staff` VALUES ('4', '韦小宝', '23', '4294967295', '膳食房', '大内总管', '扬州', '5000', '无', '立春苑');
INSERT INTO `staff` VALUES ('5', '韦小宝', '23', '4294967295', '膳食房', '大内总管', '扬州', '5000', '无', '立春苑');
运行实例 »
点击 "运行实例" 按钮查看在线实例