MYSQL

quan圈钱钱

于 2024-05-17 11:39:43 发布

阅读量112

点赞数 1

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/quanqianqian/article/details/139000909

版权

ddl

CREATE TABLE student (
  id INT PRIMARY KEY AUTO_INCREMENT,
  createDate DATE,
  userName VARCHAR(255),
  phone VARCHAR(15),
  age INT,
  sex CHAR(1),
  introduce TEXT
);

dml

INSERT INTO student (createDate, userName, phone, age, sex, introduce) VALUES
('2023-01-01', '张三', '12345678901', 20, '男', '我是张三，喜欢读书。'),
('2023-02-01', '李四', '23456789012', 21, '男', '我是李四，喜欢运动。'),
('2023-03-01', '王五', '34567890123', 22, '女', '我是王五，喜欢音乐。'),
('2023-04-01', '赵六', '45678901234', 23, '女', '我是赵六，喜欢画画。'),
('2023-05-01', '孙七', '56789012345', 24, '男', '我是孙七，喜欢旅行。'),
('2023-06-01', '周八', '67890123456', 25, '女', '我是周八，喜欢摄影。'),
('2023-07-01', '吴九', '78901234567', 26, '男', '我是吴九，喜欢编程。');

DQL

SELECT
  id,
  createDate,
  userName,
  phone,
  age,
  sex,
  introduce,
  CASE
    WHEN sex = '男' THEN '爷们'
    WHEN sex = '女' THEN '姑娘'
    ELSE '未知'
  END AS description
FROM
  student;