— 创建数据库
CREATE DATABASE my_db;
— 选择该数据库
USE my_db;
— 创建表
CREATE TABLE user (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(20) NOT NULL,
age INT NOT NULL,
gender CHAR(2)
);
— 插入数据
INSERT INTO user (name, age, gender) VALUES (‘Tom’, 21, ‘男’);
INSERT INTO user (name, age, gender) VALUES (‘Lucy’, 23, ‘女’);
INSERT INTO user (name, age) VALUES (‘Jack’, 24);
— 查询表中全部数据
SELECT * FROM user;
— 按照条件查询数据
SELECT * FROM user WHERE gender = ‘男’ AND age >20;
— 更新数据
UPDATE user SET age = 22 WHERE name = ‘Tom’;
— 删除数据
DELETE FROM user WHERE age
MySQL数据库是广泛使用的关系型数据库，熟练掌握MySQL对于日常开发和数据处理非常重要。如果您想更深入地了解MySQL，尚硅谷宋红康老师的MySQL课程值得一试。
