mysql> select uid, app_id from user_ext_0 into outfile '/app/tmp_dat/user_for_login_tmp_ca_0.dat' fields terminated by '|';
报错信息如下:
ERROR 1 (HY000) at line 1: Can't create/write to file '/app/tmp_dat/user_for_login_tmp_ca_0.dat' (Errcode: 13) 错误。
ll 后发现 /app/tmp_dat 目录的没有修改的权限
解决的办法是:
chmod 775 /app/tmp_dat