mysql中创建表的时候，如何给字段写备注

mysql> create table stu_info (name varchar(20) comment "this is student name");
Query OK, 0 rows affected (0.01 sec)


mysql> show create table stu_info;
+----------+-----------------------------------------------------------------------------------------------------------------------------------+
| Table    | Create Table                                                                                                                      |
+----------+-----------------------------------------------------------------------------------------------------------------------------------+
| stu_info | CREATE TABLE `stu_info` (
  `name` varchar(20) DEFAULT NULL COMMENT 'this is student name'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+----------+-----------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)