-- Table structure for user
DROP TABLE IF EXISTS user;
CREATE TABLE user (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
name varchar(30) DEFAULT NULL COMMENT '姓名',
age int(11) DEFAULT NULL COMMENT '年龄',
email varchar(50) DEFAULT NULL COMMENT '邮箱',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
-- Records of user
INSERT INTO user VALUES ('1', 'Jone', '18', '[email protected]');
INSERT INTO user VALUES ('2', 'Jack', '20', '[email protected]');
INSERT INTO user VALUES ('3', 'Tom', '28', '[email protected]');
INSERT INTO user VALUES ('4', 'Sandy', '21', '[email protected]');
INSERT INTO user VALUES ('5', 'Billie', '24', '[email protected]');
INSERT INTO user VALUES ('6', 'xiaohua', '45', '[email protected]');
INSERT INTO user VALUES ('7', 'zhangsi', '18', '[email protected]');
INSERT INTO user VALUES ('11', 'wanger02', '15', '[email protected]');
INSERT INTO user VALUES ('12', 'wanger02', '15', '[email protected]');s