[google-cloud-sql-discuss] Re: OR 1148 (42000): The used command is not allowed with this MySQL version

This depends on where you're running that query. It will work if you're running this from the mysql client on your local machine, which will call mysqlimport with the '--local' option to read the local file. Anywhere else it will fail (not the least because there would be no way to access your C:/ drive).

This assumes your database is a Google Cloud SQL instance, is this correct?

On Friday, March 24, 2017 at 9:20:35 AM UTC-4, Rajiv Chaturvedi wrote:

Hi,

Does anyone get this error when loading a csv file into a MYSQL table?  The database is on google cloud

OR 1148 (42000): The used command is not allowed with this MySQL version

LOAD DATA LOCAL INFILE 'c:/Users/user/Desktop/products_export.csv' INTO TABLE Products
        COLUMNS TERMINATED BY ','
        LINES TERMINATED BY '\r\n';

Thanks

Rajiv

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/107f3d1c-df56-4128-8102-932563b57985%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.