1. 查看数据库所有表
show tables
2. 显示表结构
show columns from 表名;
4.更改表元素
update tb_info set dizhi='牧野区',xingbie='男' where xuesheng='张冬雪';
5 查看表结构
desc dev_info;
6.删除表中所有数据
delete from share_record;
7.查看数据库大小
select concat(round(sum(DATA_LENGTH/1024/1024),2)) as data from information_schema.TABLES where table_schema='videoas' and table_name='sipcall_info';
8 只查询10条记录
select * from request_log limit 10;