After MySQL ODBC 5.1 is installed in MySQL 5.1, an error 2005/2008 error occurs when you use the import and export tool that comes with SQL Server 42000. A large number of English letters indicate syntax errors, it must be an SQL statement generated by SQL Server. MySQL does not recognize it. After some Google operations, I finally found a solution:
Start to enter the command:
Mysql-H 61.178.8.213-u root-P
Enter Password :*******
Welcome to the MySQL monitor. commands end with; or \ G.
Your MySQL connection ID is 14030
Server version: 5.1.40-Community MySQL Community Server (GPL)
Copyright (c) 2000,201 0, Oracle and/or its affiliates. All rights reserved.
This software comes with absolutely no warranty. This is free software,
And you are welcome to modify and redistribute it under the GPL V2 license
Type 'help; 'or' \ H' for help. type' \ C' to clear the current input statement.
Mysql> select @ Global. SQL _mode;
+ ---------------------------------------------------------------- +
| @ Global. SQL _mode |
+ ---------------------------------------------------------------- +
| Strict_trans_tables, no_auto_create_user, no_engine_substitution |
+ ---------------------------------------------------------------- +
1 row in SET (0.03 Sec)
Mysql> set global SQL _mode = 'ansi ';
Query OK, 0 rows affected (0.02 Sec)
Mysql> select @ Global. SQL _mode;
+ ------------------------------------------------------------- +
| @ Global. SQL _mode |
+ ------------------------------------------------------------- +
| Real_as_float, pipes_as_concat, ansi_quotes, ignore_space, ANSI |
+ ------------------------------------------------------------- +
1 row in SET (0.01 Sec)
Now, there is no problem. It turns out that SQL _mode is not caused by ANSI. Really cool ~