CREATE TABLE student( id INT PRIMARY KEY AUTO_INCREMENT COMMENT '學號', name VARCHAR(200) COMMENT '姓名', age int COMMENT '年齡' ) COMMENT='學生信息' 2.修改注釋
修改表注釋-ALTER TABLE student COMMENT '學生表';
修改列注釋-ALTER TABLE student MODIFY COLUMN name VARCHAR(100) COMMENT '姓名';
SELECT table_name,table_comment FROM information_schema.tables WHERE table_schema = '所在的db' AND table_name ='表名groups' SHOW FULL COLUMNS FROM groups -- 這個可以按條件的去搜索某名字或某數據類型的列的信息：例如
SHOW FULL COLUMNS FROM tableName WHERE FIELD = 'add_time' OR TYPE LIKE '%date%' -- 查看tableName表中列名是add_time的或類型是date的列 SELECT column_name, column_comment FROM information_schema.columns WHERE table_schema ='db' AND table_name = 'groups' SHOW CREATE TABLE communication_group 到此，相信大家對“mysql建表如何添加注釋”有了更深的了解，不妨來實際操作一番吧！
