- CONCAT(A.db,'.',A.tb) dbtb1,
- CONCAT(IFNULL(B.db,''),'.',IFNULL(B.tb,'')) dbtb2,engine
- FROM
- (
- SELECT
- table_schema db,table_name tb,engine
- FROM
- information_schema.tables
- WHERE
- table_schema=mydb and table_name=mytb
- ) A
- LEFT JOIN
- (
- SELECT
- table_schema db,table_name tb
- FROM
- information_schema.tables
- WHERE
- table_schema=mydb and table_name=mytb AND engine='InnoDB'
- ) B
- USING
- (db,tb)
+ CCSA.character_set_name csname
+ FROM
+ information_schema.`TABLES` T,
+ information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA
+ WHERE
+ CCSA.collation_name = T.table_collation
+ AND
+ T.table_schema = mydb
+ AND
+ T.table_name = mytb
+
+