import mysql dump file with double quoted identifer

not completed, seems not working....

if the file is small, just edit the dump file by adding a statement that changes session's sql mode to support double quoted identifiers.

SET @@SESSION.sql_mode='ansi';

if the file is large and you can't open to edit it, the sql mode can be retrieved and then be set to ansi. after the importing, the sql mode need to be set back to its original value.

mysql -u -p --execute "SELECT @@GLOBAL.sql_mode;"
mysql -u -p --execute "SET @@GLOBAL.sql_mode='ansi';"
mysql -u -p db