Query ตาราง INFORMATION_SCHEMA.COLUMNS กรอง DATA_TYPE = 'text' เพื่อหาคอลัมน์ชนิด TEXT ทั้งหมด
คำสั่งค้นหา
mysql> SELECT TABLE_NAME, COLUMN_NAME
-> FROM INFORMATION_SCHEMA.COLUMNS
-> WHERE DATA_TYPE = 'text';ผลลัพธ์ตัวอย่าง (บางส่วนจาก 240 แถว)
+---------------------------------------------+--------------------------------+
| TABLE_NAME | COLUMN_NAME |
+---------------------------------------------+--------------------------------+
| COLUMNS | COLUMN_DEFAULT |
| COLUMNS | COLUMN_COMMENT |
| FILES | FILE_NAME |
| PARTITIONS | PARTITION_DESCRIPTION |
| PARTITIONS | PARTITION_COMMENT |
| ROUTINES | ROUTINE_COMMENT |
| replication_group_member_stats | LAST_CONFLICT_FREE_TRANSACTION |
| password_history | Password |
| component | component_urn |
| innodb_buffer_stats_by_schema | object_schema |
| innodb_buffer_stats_by_schema | allocated |
| innodb_buffer_stats_by_schema | data |
| texturl | URLID |
| textdemo | name |
| texttabledemo | Address |
| searchtextdemo | BookName |
| retrievefirst40characters | AllWords |
| lastindexstring | yourURL |
| stringcontainsnumber | Words |
| occurrencesofcharacter | sentence |
| textdemo | sentence |
| countvaluescommaseparated | CommaSeparatedValue |
| removedemo | Name |
| viewtabledemo | UserComments |
| usercommentsview | UserComments |
| userinformation | UserPost |
| avoidinserterrordemo | Sentence |
| extracttuples | Comments |
| findbestmatch | UserQuery |
| user | authentication_string |
| help_topic | description |
| help_topic | example |
| help_topic | url |
| help_category | url |
| slave_relay_log_info | Relay_log_name |
| slave_relay_log_info | Master_log_name |
| slave_master_info | Master_log_name |
| slave_master_info | User_name |
| slave_master_info | User_password |
| slave_master_info | Ssl_ca |
| slave_master_info | Ssl_capath |
| slave_master_info | Ssl_cert |
| slave_master_info | Ssl_cipher |
| slave_master_info | Ssl_key |
| slave_master_info | Bind |
| slave_master_info | Ignored_server_ids |
| slave_master_info | Uuid |
| slave_master_info | Ssl_crl |
| slave_master_info | Ssl_crlpath |
| slave_master_info | Tls_version |
| slave_master_info | Public_key_path |
| slave_worker_info | Relay_log_name |
| slave_worker_info | Master_log_name |
| slave_worker_info | Checkpoint_relay_log_name |
| slave_worker_info | Checkpoint_master_log_name |
| posts | post_content |
| updatestringdemo | FileName |
| selectrowdemo | Message |
| findstringwithgivenprefixdemo | UserMessage |
| getfileextensiondemo | File_Name |
| addtoexistingvaluedemo | Instructor_TechnicalSubject |
| findreplacedemo | FileDirectory |
| trimcommasdemo | AllTechnicalSkills |
| countallcharactersdemo | UserSubject |
| wheresetdemo | UserFavouriteSubject |
| addexistingvaluedemo | StudentTechnicalSubject |
| demotable34 | ProgramExtension1 |
| demotable34 | ProgramExtension2 |
| demotable34 | ImageExtension |
| demotable95 | Information |
| demotabel101 | URL |
| demotable160 | FileName |
| demotable164 | Header |
| demotable165 | Value |
| DemoTable | CustomerAllProductPrice |
| DemoTable | Title |
+---------------------------------------------+--------------------------------+ประโยชน์: ตรวจสอบ schema, วางแผน migration, หาตารางที่เก็บข้อความยาว, Audit ชนิดข้อมูล
ชนิด TEXT ทั้งหมด: TINYTEXT (255), TEXT (64KB), MEDIUMTEXT (16MB), LONGTEXT (4GB) — ทั้งหมดจะมี DATA_TYPE = 'text'
