mysql SELECT TABLE_NAME table_schema TABLE_COLLATION FROM information_

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
mysql> SELECT TABLE_NAME, table_schema, TABLE_COLLATION FROM information_schema.tables where table_schema='cresdb';
+-----------------------------------+--------------+-----------------+
| TABLE_NAME | table_schema | TABLE_COLLATION |
+-----------------------------------+--------------+-----------------+
| QBLOB_TRIGGERS | cresdb | utf8_general_ci |
| QCALENDARS | cresdb | utf8_general_ci |
| QCRON_TRIGGERS | cresdb | utf8_general_ci |
| QFIRED_TRIGGERS | cresdb | utf8_general_ci |
| QJOB_DETAILS | cresdb | utf8_general_ci |
| QJOB_LISTENERS | cresdb | utf8_general_ci |
| QLOCKS | cresdb | utf8_general_ci |
| QPAUSED_TRIGGER_GRPS | cresdb | utf8_general_ci |
| QSCHEDULER_STATE | cresdb | utf8_general_ci |
| QSIMPLE_TRIGGERS | cresdb | utf8_general_ci |
| QTRIGGERS | cresdb | utf8_general_ci |
| QTRIGGER_LISTENERS | cresdb | utf8_general_ci |
| T_ACCOUNT | cresdb | utf8_general_ci |
| T_ACCOUNTDOMAINS | cresdb | utf8_general_ci |
| T_ACCOUNTGROUP | cresdb | utf8_general_ci |
| T_ACCOUNTPROFILE | cresdb | utf8_general_ci |
| T_ACCOUNTROLES | cresdb | utf8_general_ci |
| T_ACCOUNTTOKENS | cresdb | utf8_general_ci |
| T_ACL | cresdb | utf8_general_ci |
| T_ACLENTRIES | cresdb | utf8_general_ci |
| T_ADDRESSBOOK | cresdb | utf8_general_ci |
| T_ADDRESSBOOKMAP | cresdb | utf8_general_ci |
| T_AUDITTRAIL | cresdb | utf8_general_ci |
| T_AUDITTRAIL_ORG | cresdb | utf8_general_ci |
| T_CERTIFICATESTORE | cresdb | utf8_general_ci |
| T_CERTSTOREMAP | cresdb | utf8_general_ci |
| T_CONTACT | cresdb | utf8_general_ci |
| T_CONTENT | cresdb | utf8_general_ci |
| T_CONTENTDATA | cresdb | utf8_general_ci |
| T_CRLSTORE | cresdb | utf8_general_ci |
| T_CUSTOMCONTACT | cresdb | utf8_general_ci |
| T_CUSTOMCONTENT | cresdb | utf8_general_ci |
| T_CUSTOMTRACKING | cresdb | utf8_general_ci |
| T_EMAILADDRESS | cresdb | utf8_general_ci |
| T_GENID | cresdb | utf8_general_ci |
| T_GROUP | cresdb | utf8_general_ci |
| T_IMPORT_STATUS | cresdb | utf8_general_ci |
| T_JOBINFO | cresdb | utf8_general_ci |
| T_KEYSTORE | cresdb | utf8_general_ci |
| T_LOGININFO | cresdb | utf8_general_ci |
| T_MAILBOX | cresdb | utf8_general_ci |
| T_MAILBOXALIASES | cresdb | utf8_general_ci |
| T_MAILBOXFOLDERS | cresdb | utf8_general_ci |
| T_MAILBOXMSGS | cresdb | utf8_general_ci |
| T_PASSWORDHISTORY | cresdb | utf8_general_ci |
| T_PERMISSION | cresdb | utf8_general_ci |
| T_PHONE | cresdb | utf8_general_ci |
| T_PROPERTIES | cresdb | utf8_general_ci |
| T_RESPONSELOG | cresdb | utf8_general_ci |
| T_ROLE | cresdb | utf8_general_ci |
| T_ROLEPERMISSIONS | cresdb | utf8_general_ci |
| T_RULESET | cresdb | utf8_general_ci |
| T_RULESETENTRY | cresdb | utf8_general_ci |
| T_SENDERREGISTRATION | cresdb | utf8_general_ci |
| T_SERVER | cresdb | utf8_general_ci |
| T_SERVERRULE | cresdb | utf8_general_ci |
| T_SERVERRULEPARAM | cresdb | utf8_general_ci |
| T_SPOOL | cresdb | utf8_general_ci |
| T_SRVRRULEUSRPARAM | cresdb | utf8_general_ci |
| T_STREETADDRESS | cresdb | utf8_general_ci |
| T_TOKENS | cresdb | utf8_general_ci |
| T_TRACKING | cresdb | utf8_general_ci |
| T_TRACKINGHISTORY | cresdb | utf8_general_ci |
| T_TRACKINGRECIPS | cresdb | utf8_general_ci |
| T_TRACKINGRECIPS_BACKUP_OLDFORMAT | cresdb | utf8_general_ci |
| T_TRACKING_BACKUP_OLDFORMAT | cresdb | utf8_general_ci |
| T_USER | cresdb | utf8_general_ci |
| T_USERGROUP | cresdb | utf8_general_ci |
| T_USERMAILBOXMAP | cresdb | utf8_general_ci |
| T_USERMAP | cresdb | utf8_general_ci |
| T_USERPROFILE | cresdb | utf8_general_ci |
| T_UUID | cresdb | utf8_general_ci |
| T_UUIDENTRIES | cresdb | utf8_general_ci |
| hibernate_unique_key | cresdb | utf8_general_ci |
+-----------------------------------+--------------+-----------------+
74 rows in set (0.01 sec)
mysql>
mysql> show full columns from T_ACCOUNT;
+-------------------------------+--------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+-------------------------------+--------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
| C_ACCOUNTID | int(11) | NULL | NO | PRI | NULL | | select,insert,update,references | |
| C_ACCOUNTNUMBER | varchar(12) | utf8_general_ci | NO | | NULL | | select,insert,update,references | |
| C_NAME | varchar(90) | utf8_general_ci | NO | UNI | NULL | | select,insert,update,references | |
| C_DESCRIPTION | varchar(255) | utf8_general_ci | YES | | NULL | | select,insert,update,references | |
| C_RULESETID | int(11) | NULL | YES | | NULL | | select,insert,update,references | |
| C_STATUS | int(11) | NULL | NO | | NULL | | select,insert,update,references | |
| C_SREG | smallint(6) | NULL | YES | | NULL | | select,insert,update,references | |
| C_TLS_ERR_PREF | int(11) | NULL | NO | | NULL | | select,insert,update,references | |
| C_CREATEDDATE | datetime | NULL | NO | | NULL | | select,insert,update,references | |
| C_CREATEDBY | int(11) | NULL | NO | | NULL | | select,insert,update,references | |
| C_AUTO_PROVISION | smallint(6) | NULL | NO | | NULL | | select,insert,update,references | |
| C_SSO_PROTOCOL | varchar(50) | utf8_general_ci | YES | | NULL | | select,insert,update,references | |
| C_SSO_EMAIL_ATTRIBUTE | varchar(50) | utf8_general_ci | YES | | NULL | | select,insert,update,references | |
| C_SSO_SP_ID | varchar(255) | utf8_general_ci | YES | | NULL | | select,insert,update,references | |
| C_SSO_SERVICE_URL | varchar(255) | utf8_general_ci | YES | | NULL | | select,insert,update,references | |
| C_SSO_LOGOUT_URL | varchar(255) | utf8_general_ci | YES | | NULL | | select,insert,update,references | |
| C_SSO_IDP_SIGNING_CERT | mediumblob | NULL | YES | | NULL | | select,insert,update,references | |
| C_SSO_SP_SIGNING_CERT | mediumblob | NULL | YES | | NULL | | select,insert,update,references | |
| C_SSO_FLAGS | int(11) | NULL | YES | | NULL | | select,insert,update,references | |
| C_SSO_ENABLEDATE | datetime | NULL | YES | | NULL | | select,insert,update,references | |
| C_MIGRATION_ENABLED | smallint(6) | NULL | YES | | NULL | | select,insert,update,references | |
| C_MIGRATION_START | datetime | NULL | YES | | NULL | | select,insert,update,references | |
| C_MIGRATION_END | datetime | NULL | YES | | NULL | | select,insert,update,references | |
| C_MIGRATION_EXISTS_CONFLICT | int(11) | NULL | YES | | NULL | | select,insert,update,references | |
| C_MIGRATION_UPTODATE_CONFLICT | int(11) | NULL | YES | | NULL | | select,insert,update,references | |
| C_MIGRATION_SECURE_KEY | varchar(100) | utf8_general_ci | YES | | NULL | | select,insert,update,references | |
+-------------------------------+--------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
26 rows in set (0.01 sec)