数据库的编写

数据库的编写

建库建表添加数据查询数据

代码 属性及备注

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;