分类：MySQL数据库导出报错解答

2021
02-26

MySQL数据库导入导出数据之报错解答实例讲解

导出数据报错SHOWVARIABLESLIKE"secure_file_priv";查看默认导出目录mysql>SELECT*FROMstudentINTOOUTFILE"G:\ProgramData\MySQL\MySQLServer8.0\Uploads\student.txt";ERROR1290(HY000):TheMySQLserverisrunningwiththe--secure-file-privoptionsoitcannotexecutethisstatement解决方法SELECT*FROMstudentINTOOUTFILE"G:/ProgramData/MySQL/MySQLServer8.0/Uploads/student.txt";QueryOK,... 继续阅读 >