我有一个SQL数据库,并想写一个脚本,将表"European_option_info“保存为文本(或excel)文件到本地文件夹。
我使用以下代码:
use database;
select * into outfile 'C:\[...]\Dropbox\Employees.txt' FIELDS TERMINATED BY ';' from European_option_info;
这会给我以下错误:
"Error Code: 1. Can't create/write to file 'C:[]\Employees.txt