进入mysql数据库,输入如下sql语句:
select id, name, age from tablename into outfile '/tmp/xxx.csv';
请注意权限问题,如果实在不行,放在/tmp 目录下
{{uploading-image-863653.png(uploading...)}}
进入mysql数据库,输入如下sql语句:
select id, name, age from tablename into outfile '/tmp/xxx.csv';
请注意权限问题,如果实在不行,放在/tmp 目录下
{{uploading-image-863653.png(uploading...)}}