mysqlテーブル文の作成と注釈の追加

テーブルの作成+コメント

CREATE TABLE student(
  id INT PRIMARY KEY AUTO_INCREMENT COMMENT '  ',
  name VARCHAR(200) COMMENT '  ',
  age    int COMMENT '  '
) COMMENT='    '

コメントの変更

     -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