我无法让以下代码生成任何输出。MySQL用户拥有"所有"授权级别,/tmp目录可写,查询返回结果集。
mysql> SELECT field FROM test_table WHERE condition='test'
-> INTO OUTFILE '/tmp/test.csv'
-> FIELDS TERMINATED BY ','
-> ENCLOSED BY '"'
-> LINES TERMINATED BY '\n';
Query OK, 1 row affected (0.00 sec)
mysql>
[1]+ Stopped mysql
[root@web1 ~]# cat /tmp/test.csv
cat: /tmp/test.csv: No such file or directory
如果MySQL发生故障,我是否应该看到不同的输出?
除了“1行受影响”的结果,我还能进一步验证结果吗?