mysql 怎么导入/导出2个关联表中的数据
表一
idstudent
1S1
2S2
表二
idsidscordorder
111001
21602
31803
42601
52602
62803
721004
导出后的格式为：---怎么实现？？？？
idstudentscordorder
1S11001
2S1602
3S1803
4S2601
5S2602
6S2803
7S21004
[解决办法]
select a.*,b.scord,b.order INTO OUTFILE '/tmp/result.CSV'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
from 表一 a inner join 表二 b on a.id=b.sid
[解决办法]
SELECT a.*,b.scord,b.order
FROM 表一 a INNER JOIN 表二 b ON a.id=b.sid
INTO OUTFILE 'xxx.txt'
FIELDS TERMINATED BY '\t'
[解决办法]
select b.id,a.student, b.scord,b.orderer
into OUTFILE 'C:\\result.CSV'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
from 第一张表 a inner join 第二张表 b on a.id = b.sid
输出结果保存到c盘
