SHOW CREATE TABLE doesn't properly escape quotes in comments

[fulghum]

When generating a CREATE TABLE statement for a table that contains comments, quotes in the comments are not properly escaped, resulting in a CREATE TABLE statement that can't be executed.

Repro:

create table t (pk int comment 'this, it''s the way to go');
Query OK, 0 rows affected (0.02 sec)

show create table t;
+-------+-----------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                      |
+-------+-----------------------------------------------------------------------------------------------------------------------------------+
| t     | CREATE TABLE `t` (
  `pk` int COMMENT 'this, it's the way to go'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin |
+-------+-----------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)