CREATE DATABASE `PersonMange` CHARACTER
SET utf8;
USE PersonMange;
CREATE TABLE Person (
id INT PRIMARY KEY Auto_Increment,
#人员ID
NAME VARCHAR ( 15 ) NOT NULL,
#人员信息
age INT DEFAULT NULL,
#人员年龄
gender VARCHAR ( 5 ) DEFAULT '保密'
#人员性别
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4;
INSERT INTO person(NAME,age,gender) VALUES ('欧楚杨',22,'保密')
INSERT INTO person(NAME,age,gender) VALUES ('杨琦璇',21,'女')
INSERT INTO person(NAME,age,gender) VALUES ('徐彰',20,'男')
INSERT INTO person(NAME,age,gender) VALUES ('衣朗',18,'男')
INSERT INTO person(NAME,age,gender) VALUES ('JAVA',8,'保密')
