Gus Mueller

gus_demo : db tools : Enter Raw SQL

show create table gus_demo.tf_concordance_hit SQL script. Use the names of fields prepended with '$' to refer to the data of those fields to be processed by subqueries enclosed in {}, which can nest inside other subqueries. {eliminate squiggly brackets from Drupal SQL}
PHP script to run on displayed columns. Use the names of fields prepended with '$' to refer to the data of those fields to be processed by the script.
URL of this page's state allow direct editing of results truncate fields

Results of Query #1
Table	Create Table
tf_concordance_hit	CREATE TABLE `tf_concordance_hit` ( `concordance_hit_id` int(11) NOT NULL AUTO_INCREMENT, `concordance_id` int(11) DEFAULT NULL, `table_source_pk` char(1) DEFAULT NULL, `table_dest_pk` char(1) DEFAULT NULL, `field1_content` char(1) DEFAULT NULL, `field2_content` char(1) DEFAULT NULL, `readfield_content` char(1) DEFAULT NULL, `source_matchcount` int(11) DEFAULT NULL, `dest_matchcount` int(11) DEFAULT NULL, `fieldtowrite_content` char(1) DEFAULT NULL, PRIMARY KEY (`concordance_hit_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci	Delete

1 row affected.
Uptime: 3694528 Threads: 79 Questions: 1563535526 Slow queries: 302 Opens: 4799767 Open tables: 15000 Queries per second avg: 423.203