方案１：
danielluo@danielluo:/tmp$ mysql -uroot -proot -e"use formax_p2p;show tables;"
+----------------------+
| Tables_in_formax_p2p |
+----------------------+
| p2p_staff |
| p2p_staff_salary |
+----------------------+
方案２：
新建一个shell脚本，格式如下：
#!/bin/bash mysql -u* -h* -p* <<EOF SQL script EOF
例如：
#!/bin/bash mysql -uroot -ppassword
use text;
CREATE TABLE user (
id varchar(36) NOT NULL COMMENT '主键',
username varchar(50) NOT NULL COMMENT '用户名',
password varchar(50) NOT NULL COMMENT '用户密码',
createdate date NOT NULL COMMENT '创建时间',
age int(11) NOT NULL COMMENT '年龄',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户信息表';
方案３：
创建t.sql:
SET NAMES utf8;
SELECT B.project_name, C.activity_name, A.customer_uid, FROM_UNIXTIME(F.reg_time) AS reg_time,
FROM_UNIXTIME(G.distribute_create_time) AS dis_time, D.user_id, D.realname
FROM t.presale_distribute_customer A
LEFT JOIN t.presale_project B ON A.project_id = B.project_id
LEFT JOIN t.presale_activity C ON A.activity_id=C.activity_id
LEFT JOIN t_newcrm.sales D ON A.user_in_charge=D.user_id
LEFT JOIN t_newcrm.customers F ON A.customer_uid=F.uid
LEFT JOIN t.presale_distribute G ON A.distribute_id = G.distribute_id
LIMIT 10;
mysql -uroot -proot < t.sql
导入数据到csv:
mysql -uroot -proot < t.sql >t.csv
