ในการตั้งค่าตัวกรองสำหรับประเภท คุณสามารถใช้ไวยากรณ์ด้านล่าง −
เลือก TABLE_NAME, COLUMN_NAMEFROM INFORMATION_SCHEMA.COLUMNSWHERE DATA_TYPE ='yourDataTypeName';
ให้เราใช้ไวยากรณ์ข้างต้นเพื่อแสดงฟิลด์ที่มีข้อความประเภทฟิลด์เท่านั้น -
mysql> SELECTTABLE_NAME, COLUMN_NAMEFROMINFORMATION_SCHEMA.COLUMNSWHEREDATA_TYPE ='ข้อความ';
สิ่งนี้จะสร้างผลลัพธ์ต่อไปนี้ -
<ก่อนหน้า>+---------------------------------------------+ --------------------+| TABLE_NAME | COLUMN_NAME |+----------------------------------------------------------+- -------------------------------------+| คอลัมน์ | COLUMN_DEFAULT || คอลัมน์ | COLUMN_COMMENT || ไฟล์ | FILE_NAME || พาร์ติชั่น | PARTITION_DESCRIPTION || พาร์ติชั่น | PARTITION_COMMENT || เส้นทาง | ROUTINE_COMMENT || replication_group_member_stats | LAST_CONFLICT_FREE_TRANSACTION || password_history | รหัสผ่าน || องค์ประกอบ | component_urn || innodb_buffer_stats_by_schema | object_schema || innodb_buffer_stats_by_schema | จัดสรร || innodb_buffer_stats_by_schema | ข้อมูล || x$innodb_buffer_stats_by_schema | object_schema || innodb_buffer_stats_by_table | object_schema || innodb_buffer_stats_by_table | object_name || innodb_buffer_stats_by_table | จัดสรร || innodb_buffer_stats_by_table | ข้อมูล || x$innodb_buffer_stats_by_table | object_schema || x$innodb_buffer_stats_by_table | object_name || x$schema_flattened_keys | index_columns || schema_redundant_indexes | redundant_index_columns || schema_redundant_indexes | dominant_index_columns || ล่าสุด_file_io | เวลาแฝง || ล่าสุด_file_io | ขอ || io_by_thread_by_latency | Total_latency || io_by_thread_by_latency | min_latency || io_by_thread_by_latency | avg_latency || io_by_thread_by_latency | max_latency || io_global_by_file_by_bytes | total_read || io_global_by_file_by_bytes | avg_read || io_global_by_file_by_bytes | Total_write || io_global_by_file_by_bytes | avg_write || io_global_by_file_by_bytes | รวม || io_global_by_file_by_latency | Total_latency || io_global_by_file_by_latency | read_latency || io_global_by_file_by_latency | write_latency || io_global_by_file_by_latency | misc_latency || io_global_by_wait_by_bytes | Total_latency || io_global_by_wait_by_bytes | min_latency || io_global_by_wait_by_bytes | avg_latency || io_global_by_wait_by_bytes | max_latency || io_global_by_wait_by_bytes | total_read || io_global_by_wait_by_bytes | avg_read || io_global_by_wait_by_bytes | Total_write || io_global_by_wait_by_bytes | avg_write || io_global_by_wait_by_bytes | total_requested || io_global_by_wait_by_latency | Total_latency || io_global_by_wait_by_latency | avg_latency || io_global_by_wait_by_latency | max_latency || io_global_by_wait_by_latency | read_latency || io_global_by_wait_by_latency | write_latency || io_global_by_wait_by_latency | misc_latency || io_global_by_wait_by_latency | total_read || io_global_by_wait_by_latency | avg_read || io_global_by_wait_by_latency | Total_write || io_global_by_wait_by_latency | avg_write || memory_by_user_by_current_bytes | current_allocated || memory_by_user_by_current_bytes | current_avg_alloc || memory_by_user_by_current_bytes | current_max_alloc || memory_by_user_by_current_bytes | Total_allocated || memory_by_host_by_current_bytes | current_allocated || memory_by_host_by_current_bytes | current_avg_alloc || memory_by_host_by_current_bytes | current_max_alloc || memory_by_host_by_current_bytes | Total_allocated || memory_by_thread_by_current_bytes | current_allocated || memory_by_thread_by_current_bytes | current_avg_alloc || memory_by_thread_by_current_bytes | current_max_alloc || memory_by_thread_by_current_bytes | Total_allocated || memory_global_by_current_bytes | current_alloc || memory_global_by_current_bytes | current_avg_alloc || memory_global_by_current_bytes | high_alloc || memory_global_by_current_bytes | high_avg_alloc || memory_global_total | Total_allocated || schema_index_statistics | select_latency || schema_index_statistics | insert_latency || schema_index_statistics | update_latency || schema_index_statistics | delete_latency || schema_table_statistics | Total_latency || schema_table_statistics | fetch_latency || schema_table_statistics | insert_latency || schema_table_statistics | update_latency || schema_table_statistics | delete_latency || schema_table_statistics | io_read || schema_table_statistics | io_read_latency || schema_table_statistics | io_write || schema_table_statistics | io_write_latency || schema_table_statistics | io_misc_latency || schema_table_statistics_with_buffer | fetch_latency || schema_table_statistics_with_buffer | insert_latency || schema_table_statistics_with_buffer | update_latency || schema_table_statistics_with_buffer | delete_latency || schema_table_statistics_with_buffer | io_read || schema_table_statistics_with_buffer | io_read_latency || schema_table_statistics_with_buffer | io_write || schema_table_statistics_with_buffer | io_write_latency || schema_table_statistics_with_buffer | io_misc_latency || schema_table_statistics_with_buffer | innodb_buffer_allocated || schema_table_statistics_with_buffer | innodb_buffer_data || schema_table_statistics_with_buffer | innodb_buffer_free || schema_tables_with_full_table_scans | เวลาแฝง || schema_table_lock_waits | รอบัญชี || schema_table_lock_waits | blocking_account || x$schema_table_lock_waits | รอบัญชี || x$schema_table_lock_waits | blocking_account || statement_analysis | Total_latency || statement_analysis | max_latency || statement_analysis | avg_latency || statement_analysis | lock_latency || statement_with_full_table_scans | Total_latency || statement_with_runtimes_in_95th_percentile | Total_latency || statement_with_runtimes_in_95th_percentile | max_latency || statement_with_runtimes_in_95th_percentile | avg_latency || statement_with_sorting | Total_latency || statement_with_temp_tables | Total_latency || user_summary_by_file_io_type | เวลาแฝง || user_summary_by_file_io_type | max_latency || user_summary_by_file_io | io_latency || user_summary_by_statement_type | Total_latency || user_summary_by_statement_type | max_latency || user_summary_by_statement_type | lock_latency || user_summary_by_statement_latency | Total_latency || user_summary_by_statement_latency | max_latency || user_summary_by_statement_latency | lock_latency || user_summary_by_stages | Total_latency || user_summary_by_stages | avg_latency || user_summary | statement_latency || user_summary | statement_avg_latency || user_summary | file_io_latency || user_summary | current_memory || user_summary | Total_memory_allocated || host_summary_by_file_io_type | Total_latency || host_summary_by_file_io_type | max_latency || host_summary_by_file_io | io_latency || host_summary_by_statement_type | Total_latency || host_summary_by_statement_type | max_latency || host_summary_by_statement_type | lock_latency || host_summary_by_statement_latency | Total_latency || host_summary_by_statement_latency | max_latency || host_summary_by_statement_latency | lock_latency || host_summary_by_stages | Total_latency || host_summary_by_stages | avg_latency || host_summary | statement_latency || host_summary | statement_avg_latency || host_summary | file_io_latency || host_summary | current_memory || host_summary | Total_memory_allocated || wait_classes_global_by_avg_latency | Total_latency || wait_classes_global_by_avg_latency | min_latency || wait_classes_global_by_avg_latency | avg_latency || wait_classes_global_by_avg_latency | max_latency || wait_classes_global_by_latency | Total_latency || wait_classes_global_by_latency | min_latency || wait_classes_global_by_latency | avg_latency || wait_classes_global_by_latency | max_latency || waits_by_user_by_latency | Total_latency || waits_by_user_by_latency | avg_latency || waits_by_user_by_latency | max_latency || waits_by_host_by_latency | Total_latency || waits_by_host_by_latency | avg_latency || waits_by_host_by_latency | max_latency || waits_global_by_latency | Total_latency || waits_global_by_latency | avg_latency || waits_global_by_latency | max_latency || รายชื่อกระบวนการ | statement_latency || รายชื่อกระบวนการ | lock_latency || รายชื่อกระบวนการ | last_statement_latency || รายชื่อกระบวนการ | current_memory || รายชื่อกระบวนการ | last_wait_latency || รายชื่อกระบวนการ | trx_latency || เซสชั่น | statement_latency || เซสชั่น | lock_latency || เซสชั่น | last_statement_latency || เซสชั่น | current_memory || เซสชั่น | last_wait_latency || เซสชั่น | trx_latency || INNODB_COLUMNS | DEFAULT_VALUE || texturl | URLID || textdemo | ชื่อ || texttabledemo | ที่อยู่ || searchtextdemo | ชื่อหนังสือ || Retrievfirst40 ตัวอักษร | AllWords || lastindexstring | yourURL || stringcontainsnumber | คำ || เหตุการณ์ที่เกิดขึ้นของตัวละคร | ประโยค || textdemo | ประโยค || countvaluescommaseparated | จุลภาคSeparatedValue || ลบอีโม | ชื่อ || viewtabledemo | ความคิดเห็นของผู้ใช้ || usercommentsview | ความคิดเห็นของผู้ใช้ || ข้อมูลผู้ใช้ | UserPost || หลีกเลี่ยงinserterrordemo | ตัวอย่างประโยค || สารสกัด | ความคิดเห็น || findbestmatch | UserQuery || ผู้ใช้ | Authentication_string || help_topic | คำอธิบาย || help_topic | ตัวอย่าง || 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 | ชื่อผู้ใช้ || 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 | ผูก || slave_master_info | Ignored_server_ids || slave_master_info | อุอิด || 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 || โพสต์ | post_content || updatestringdemo | ชื่อไฟล์ || selectrowdemo | ข้อความ || findstringwithgivenprefixdemo | ข้อความผู้ใช้ || getfileextensiondemo | ไฟล์_ชื่อ || addtoexistingvaluedemo | Instructor_TechnicalSubject || findreplacedemo | FileDirectory || trimcommasdemo | ทั้งหมดTechnicalSkills || countallcharactersdemo | UserSubject || โดยที่setdemo | ผู้ใช้ที่ชื่นชอบหัวเรื่อง || addexistingvaluedemo | StudentTechnicalSubject || demotable34 | ProgramExtension1 || demotable34 | ProgramExtension2 || demotable34 | ส่วนขยายรูปภาพ || demotable95 | ข้อมูล || demotabel101 | URL || demotable160 | ชื่อไฟล์ || demotable164 | Header || demotable165 | ความคุ้มค่า || DemoTable | ลูกค้าทั้งหมดราคาสินค้า || DemoTable | ชื่อเรื่อง |+----------------------------------------------------------+- -------------------------------+240 แถวในชุด (0.28 วินาที)