MySQL常用命令

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

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