[google-cloud-sql-discuss] Re: Export from MySQL to csv and then import from the same file alters data

Hello Roman, 

If the FIELDS ESCAPED BY character is empty, as in your example, escape-sequence interpretation does not occur. Seen that no escaping occurs, your N is taken as a string, while the column data type is INT, resulting in error. You can gather more detail on escaping from the "13.2.6 LOAD DATA INFILE Syntax" documentation page for MySQL, at the level of the "FIELDS ESCAPED BY controls how to read or write special characters" sub-chapter. 

--
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/5d658736-6e01-4600-bdd3-4f0ec4a6de1a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.