into outfile 写文件

写文件text.txt到less-7目录下。

mysql> select "snow" into outfile "D:\\phpstudy_pro\\WWW\\sqli-labs\\Less-7\\test.txt";
Query OK, 1 row affected (0.00 sec)

mysql> select "snow" into outfile "D:\\phpstudy_pro\\WWW\\sqli-labs\\Less-7\\test.txt";
ERROR 1086 (HY000): File 'D:\phpstudy_pro\WWW\sqli-labs\Less-7\test.txt' already exists
mysql>

load_file()读取本地文件

mysql> select load_file("D:\\phpstudy_pro\\WWW\\sqli-labs\\Less-7\\test.txt");
+-----------------------------------------------------------------+
| load_file("D:\\phpstudy_pro\\WWW\\sqli-labs\\Less-7\\test.txt") |
+-----------------------------------------------------------------+
| snow
                                                           |
+-----------------------------------------------------------------+
1 row in set (0.00 sec)