create database test-db;

show databases;

mysql -D test-db;
mysql>use test-db;

4.1 查看有哪些表
show tables;
4.2 查看表的描述
desc talbe-name 4.3 更新/修改字段
update asset_huazi set category='动态贴图' where type = 'animate_huazi';
update asset_huazi set category='静态贴图' where type = 'static_huazi'; 4.4 查看第一个和最后一个项

第一条记录
mysql> select * from apple LIMIT 1;
默认升序，等价于

mysql> select * from apple order by asc id LIMIT 1;
最后一条记录

mysql> select * from apple order by id desc LIMIT 1;

更新表

update <table-name> set <field-name> where <filter>;