需求
建库建表添加数据查询数据
代码
属性及备注
primary key 主键
auto_increment 自动增长
代码
#建库
CREATE DATABASE hrinfo CHARACTER SET utf8;
#用库
USE hrinfo;
#建表
CREATE TABLE person(
id INT PRIMARY KEY AUTO_INCREMENT,
`name` NVARCHAR(50) NOT NULL,
sex NVARCHAR(50) NOT NULL,
age INT NOT NULL,
rank NVARCHAR(50) NOT NULL,
department NVARCHAR(100) NOT NULL
);
#添加数据
INSERT INTO person VALUES (NULL,'张三','男',18,'rank','department');
INSERT INTO person VALUES (NULL,'李四','男',18,'rank','department');
INSERT INTO person VALUES (NULL,'王五','男',18,'rank','department');
#查看表
SELECT * FROM person;