1.创建一个数据库
mysql> create database user_info
2.选中该数据库
mysql> use user_info
3.穿建一张表
create table user_account_info(user_name varchar(50),user_id int);
4.插入数据(增)
insert into user_account_info(user_name,user_id) values('123',10);
5.查看数据(查)
select* from user_account_info;
6.删除数据
delete from user_account_info where user_name = '123'
7.修改数据
update user_account_info set user_id = 10086 where user_name = '1s23';