Bug #51969 | SHOW CREATE TABLE generates a statement with pairs of single quote (“'”) | ||
---|---|---|---|
Submitted: | 11 Mar 2010 20:23 | Modified: | 7 Apr 2010 19:22 |
Reporter: | Samir Abboushi | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Workbench: SQL Editor | Severity: | S3 (Non-critical) |
Version: | 5.2.16 Beta Revision 5249 | OS: | Windows (Vista 64) |
Assigned to: | CPU Architecture: | Any | |
Tags: | SHOW CREATE TABLE |
[11 Mar 2010 20:23]
Samir Abboushi
[11 Mar 2010 21:28]
MySQL Verification Team
Thank you for the bug report.
[11 Mar 2010 22:21]
Samir Abboushi
Clarification: The 'Create Table' Column of the 'Results' tab correctly shows that values are enclosed with single quotes. Right clicking on the resulting 'Create Table' statement in the 'Results' tab, and selecting 'Copy field content' seems to be where the duplicate single quotes are added (i.e. pasting will show the duplicate single quotes)
[12 Mar 2010 4:24]
Peter Laursen
Quotes are only required for strings and should be avoided totally with numbers.
[7 Apr 2010 19:22]
Sergei Tkachenko
Please see the bug #51041 for solution.