mysql - MySQL服务器如何与google一起运行

Question

当我尝试上传表的批量数据时，出现此错误。

ERROR 1290 (SQLSTATE HY000): The MySQL server is running with the google so it cannot execute this statement

我在命令行中用于上传数据的命令(google_sql.cmd)

sql> LOAD DATA INFILE 'C\:List.txt' INTO TABLE Associate_List FIELDS TERMINATED BY ','  LINES TERMINATED BY '\n';

请帮助我。我必须使用什么语法以及如何批量上传数据？

Answer 1

在搜索引擎(例如 Google)中输入错误消息会让我认为您正在使用 Google Cloud SQL 并且您正在尝试运行不受支持的命令，如 Does Google Cloud SQL support all the features of MySQL? 中所述。 :

Unsupported MySQL statements:

Sending any of the following types of SQL statements will generate an error with the message "Error 1290: The MySQL server is running with the google option so it cannot execute this statement"

LOAD DATA INFILE
SELECT ... INTO OUTFILE
SELECT ... INTO DUMPFILE
INSTALL PLUGIN ...
UNINSTALL PLUGIN
CREATE FUNCTION ... SONAME ...