# select into outfile
SELECT * FROM student
INTO OUTFILE 'C:/student_data.txt';
/*
错误代码: 1290
The MySQL server is running with the --secure-file-priv option
so it cannot execute this statement
secure-file-priv:
NULL 禁止导出
“” 不限定位置
“c:/” 限制特定目录
修改 my.ini文件
添加一行:
secure-file-priv =
重启mysql服务
*/
CREATE TABLE stu(
SELECT * FROM student WHERE 1=2
);
LOAD DATA INFILE 'c:/student_data.txt' INTO TABLE stu;
mysql-导入和导出
最新推荐文章于 2024-05-10 10:31:50 发布