`id` int(10) unsigned NOT NULL auto_increment COMMENT '自增id',
这样之后,我要查看备注,语句是什么呢?如下是我在百度找到的一个语句:
SELECT COLUMN_NAME, DATA_TYPE AS `数据类型`, CHARACTER_MAXIMUM_LENGTH AS `字符长度`, NUMERIC_PRECISION AS `数字长度`, NUMERIC_SCALE AS `小数位数`, IS_NULLABLE AS `是否允许非空`, CASE WHEN EXTRA = 'auto_increment' THEN 1 ELSE 0 END AS `是否自增`, COLUMN_DEFAULT AS `默认值`, COLUMN_COMMENT AS `备注` FROM information_schema.COLUMNS WHERE TABLE_NAME='表名" . $table . "' AND TABLE_SCHEMA = '数据库名" . $database . "'
ALTER TABLE table_name COMMENT='这是表的注释'1.给表加注释:
ALTER TABLE table_name COMMENT='这是表的注释'2.给列加注释:
ALTER table table_name MODIFY `column_name` datetime DEFAULT NULL COMMENT '这是字段的注释'欢迎分享,转载请注明来源:内存溢出
评论列表(0条)