将MySQL中数据导入到指定文件中

13年前

select id ,name,uid

 from a_result_user

where  id >= '20101111'  

into outfile '/tmp/a_result_user'

FIELDS TERMINATED BY ','

ENCLOSED BY '"'

LINES TERMINATED BY '\n'