Mysql get table comment field operation

-- View and obtain the field comments in the table:
show full columns from tablename;
-- Or show full fields from tablename;
-- Or, look in the metadata table Select COLUMN_NAME column name, DATA_TYPE field type, COLUMN_COMMENT field comment from INFORMATION_SCHEMA.COLUMNS
Where table_name = 'companies'##table name AND table_schema = 'testhuicard'##database name AND column_name LIKE 'c_name'##field name -- 2-1 How to view table comments:
show create table tablename;
-- 2-2 Get all table information of the entire database (including table name, table comment, table type, etc.):
SELECT table_name, table_type, engine
FROM information_schema.tables
WHERE table_schema = 'db5' //table_schema is the database name ORDER BY table_name DESC;
-- This statement requests a reverse alphabetical listing of all tables in database db5, but only displays three types of information: table name, table type, and table engine.
-- INFORMATION_SCHEMA is the information database that holds information about all other databases maintained by the MySQL server.
SELECT TABLE_COMMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'sh_goods' AND TABLE_SCHEMA = 'sh_shop'; //Get the comments of the sh_goods table in the sh_shop database.
-- 2-3 Get table comments or -- or use:
show table status;
-- Comment is a table comment.
-- Extensions:
-- Modify the table's comments:
alter table test1 comment 'Comments of the modified table';
-- Modify the field's comment:
alter table test1 modify column field_name int comment 'modified field comment';

select COLUMN_NAME,DATA_TYPE,COLUMN_COMMENT from information_schema.COLUMNS where table_name = 'table name' and table_schema = 'database name';