mysql命令总结

一 常用

1 查看注释

show create table invest.t_invest_subject  \G

2 连接

mysql -u root -p --socket=/usr/local/mysql/data/mysql.sock

mysql -u root -p -h localhost --socket=/usr/local/mysql/data/mysql.sock

mysql -u root -p -h localhost -D mysql --socket=/usr/local/mysql/data/mysql.sock

mysql -u root -p -h localhost -P 3306 -D mysql --socket=/usr/local/mysql/data/mysql.sock

二 运维

1 导出

正常导出

mysqldump -u root -p --socket=/usr/local/mysql/data/mysql.sock loan t_ls_project>loan_t_ls_project;

不影响服务器导出

mysqldump -u root -p --socket=/usr/local/mysql/data/mysql.sock --single-transaction --quick invest t_recovery_order_detail>invest_t_recovery_order_detail.sql;

三 客户端乱码

修改/etc/my.cnf     my.cnf中的[mysql]或[client]下default-character-set =utf8.