mysql> SELECT a.TABLE_NAME,b.TABLE_COMMENT, a.COLUMN_NAME, a.COLUMN_TYPE, a.COLUMN_COMMENT
-> FROM information_schema.COLUMNS a JOIN information_schema.TABLES b
-> ON a.TABLE_SCHEMA = b.TABLE_SCHEMA AND a.TABLE_NAME = b.TABLE_NAME
-> WHERE a.TABLE_NAME = 'tbdevice';
