Add comments on a mysql table

CREATE TABLE testing (
name VARCHAR(5)
) COMMENT=’this is testing’;
How to view the comment:

Or add comments after making a table by
ALTER TABLE tablename COMMENT = ‘new updated comment’;

To see the comments

SHOW CREATE TABLE testing;

Source

Add comments on a mysql table CREATE …
Tagged on:

Leave a Reply

Your email address will not be published. Required fields are marked *