-- 1 创建学生表
CREATE TABLE student(
stu_num VARCHAR(10) PRIMARY KEY,
gender ENUM('男','女','保密'),
hobby SET('吃饭','睡觉','打豆豆'),
fee DECIMAL(6,2)
);
-- 2.1 插入数据
INSERT INTO student
VALUES("2023000001","男,女","吃饭,睡觉",200.12345);
INSERT INTO student
VALUES("2023000002","男","吃饭,睡觉啊",123456789.12345);
MySQL—数据类型(七)
于 2023-07-17 15:11:19 首次发布