查询所有字段名称:
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'table_name' AND TABLE_SCHEMA = 'db_name';
查询所有字段注释:
SELECT COLUMN_COMMENT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'table_name' AND TABLE_SCHEMA = 'db_name';
查看数据库编码(建表语句):
SHOW CREATE TABLE table_name;
修改数据库编码:
ALTER TABLE table_name DEFAULT CHARACTER SET UTF8;
修改字段编码:
ALTER TABLE table_name MODIFY column_name CHAR(50) CHARACTER SET utf8;