数据库基础 DML

DML

全称 Data Manipulation Language(数据操作语言)
use test;
select * from my_user;

添加

insert into my_user (username, password, age, gender, phone)
            values ('tinumb','123456',23,'男','18003852501');

修改

update my_user set password = '654321' where id = 1;

删除

delete from my_user where id = 1;