方便一些测试mysql的时候使用
登录后:
show databases;
使用一个database:
use mysql;
进去database后开始创建测试表:
create table test(
pid int primary key auto_increment,
pname varchar(30) not null,
psex varchar(4),
page int,
paddress varchar(50)
);
查看创建成功的表:
show tables;
向创建好的表插入一些数据:
insert into test values
(11,"zhangsan","m",10,"123"),
(21,"lisi","m",11,"223"),
(31,"wangwu","f",12,"323"),
(41,"zhaoliu","f",13,"423");
查看数据:
select * from test;
更新某一个数据:
update test set pid = 20 where pid = 1 ;
删除某一个数据:
delete from test where pid = 2 ;