Michal Čihař a écrit:
On 16.04.2004 12:38 +0200, Alexander M. Turek wrote:
Hi there,
Michal Cihar wrote:
I'd like to implement this one, but I'm not sure what all is needed.
- changing comment mark from # to --, this should not break
anything so there is no need to make switch for this, am I right?
Sure.
- changing ' to '', this should be also work fine as default,
shouldn't?
Haven't tested it, but it should work.
The above changes are in cvs and seems to work fine where I tested.
The problem is the table and field names: you cannot enclose them in backticks here, ANSI only allows doublequotes for this purpose. In MySQL, doublequotes may be used for strings only, so this would be a big incompatibility.
Is somewhere available some short overview of MySQL vs. ANSI SQL differences? We would probably need a checkbox for this on export page...
Michal, I don't know if you know about http://dev.mysql.com/doc/mysql/en/Compatibility.html
Marc