1、命令行连接数据库:mysql -hhostname -uroot -proot
查看数据库:show databases;
使用数据库:use database;
查看表:show tables;
查询数据:select * from tablename where id=1 limit 1;
按某字段排序:select * from tablename order by id desc limit 1;
更改数据:update tablename set id=1 where id =3;
删除数据 delete from tablename where id =4;
查看标的结构:desc tablename;
show create table tablename;
查看当前用户:select user();
查看当前数据库:select database();