Bug #5744 | mysqldump doesn't quote reserved or otherwise invalid column names | ||
---|---|---|---|
Submitted: | 25 Sep 2004 8:34 | Modified: | 28 Sep 2004 8:39 |
Reporter: | Laszlo Thoth | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: mysqldump Command-line Client | Severity: | S3 (Non-critical) |
Version: | 5.0.0-alpha-standard | OS: | Darwin 7.5.0 (MacOS X 10.3.5) |
Assigned to: | CPU Architecture: | Any |
[25 Sep 2004 8:34]
Laszlo Thoth
[26 Sep 2004 14:37]
Hartmut Holzgraefe
mysqldump does not add quotes by default but you can ask it to by calling it with the following option: -Q, --quote-names Quote table and column names with backticks (`). A dump created with this option should work just fine in your case
[28 Sep 2004 8:39]
Sergei Golubchik
Actually, mysqldump does add quotes by default - it was changed on July 2, 2004. You may upgrade to get the change.