Add comments on a mysql table CREATE …


blankety-blank Add comments on a mysql table

Birkerød 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


Leave a Reply

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