MySQL常用命令 - hokein/Wiki GitHub Wiki

// root帐号登录mysql
> mysql -uroot -p

use <database_name>;
show tables;
show columns from <table_name>;
select * from <table_name> into outfile ’/tmp/output.txt’;