SQL SERVER與MYSQL資料匯入匯出問題解決辦法

MYSQL 版本是5.1的 安裝了MYSQL ODBC 5.1之後用SQL SERVER 2005/2008內建的匯入匯出工具會提示ERROR 42000，後面一大堆英文，意思是語法錯誤，肯定是SQL SERVER產生的SQL語句，MYSQL那邊不認造成的，GOOGLE了一番，終於找到瞭解決方案：

開始輸入命令：

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, 2010, 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)

行了，現在就沒問題了，原來是SQL_MODE不是ANSI造成的。真操蛋~