Problem when copying Query from Excel to MySQL

[David Jödicke]

Hey guys,

I want to alter my table with a lot of new columns. I have the names of the columns in an Excel-Sheet. To insert these new columns easier into my database I have written a formula in Excel which creates the query for altering my table.
When I copy this query to my MySQL-Console and try to execute it i got an error:

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE webdb ADD mail_adress VARCHAR(16) NULL AFTER name' at line 1"

When I am writing the same query manualy and execute it the query works. Even when I write the query in Notepad and copy it from there it is working... I only have this problem when I copy it from Excel.
Copying from Excel to Notepad and then to MySQL doesn_t work either.

Maybe you have some ideas?

Thank you,

David