SQL Help

JohnHenrySolo

Weaksauce
Joined
Jan 30, 2011
Messages
119
Code:
select sim.sim, sim.imsi from sim inner join inventory on inventory.sim_gid = sim.sim_gid where channel_gid = 22; into outfile '/tmp/test.csv/'

I'm trying to run the above, and I am receiving no error messages. However, when I check the tmp dir...my csv file is not there.

Logged into the DB as root...
 
Update - Changed the statement around after mucking with it....got a better error.

Code:
mysql> SELECT sim.sim, sim.imsi INTO OUTFILE '/tmp/test.csv/' FROM sim INNER JOIN inventory on inventory.sim_gid = sim.sim_gid where channel_gid = 22;
ERROR 1 (HY000): Can't create/write to file '/tmp/test.csv/' (Errcode: 21)
 
Back
Top