4mysql数据表增删改查

1增

insert into t1(id,name) values(1,'alex');

2删

delete  from t1 where id<5; #where表示条件
drop table t1;

3改

update t1 set age=18;
update t1 set age=18 where age=17;

4查

select * from t1;#*可以换成其他列名，后面可以接where子句
desc db1;