browse tables
create new table
db tools
manually enter SQL
version
gus_demo
:
table concordance
:
choose tables and fields
Source Table
none
articles
articles2
articles3
building
enemyship_map
friendship_map
lifeform
mysql_errorlog
randombit
tf_browsescheme
tf_browsetype
tf_column_info
tf_concordance
tf_concordance_hit
tf_dbdiff
tf_dbdiff_table
tf_dbmap
tf_dbmap_table
tf_relation
tf_relation_type
tf_scriptlog
tf_sqllog
tf_validation_pattern
tf_validation_type
Source Field 1
none
Source Field 2
none
Source Field to Read
none
Destination Table
none
articles
articles2
articles3
building
enemyship_map
friendship_map
lifeform
mysql_errorlog
randombit
tf_browsescheme
tf_browsetype
tf_column_info
tf_concordance
tf_concordance_hit
tf_dbdiff
tf_dbdiff_table
tf_dbmap
tf_dbmap_table
tf_relation
tf_relation_type
tf_scriptlog
tf_sqllog
tf_validation_pattern
tf_validation_type
Destination Field 1
none
Destination Field 2
none
Destination Field to Write
none
The Source Table is where the data will come from. The Destination Table is where it will go. Rows in the Destination Table can have their "Destination Field to Write" fields replaced with the content of the Source Table's "Source Field to Read" for rows where the data in Source Field 1=Destination Field 1 and Source Field 2=Destination Field 2. More options are available once the matches have been scanned.
Saved Concordances
id
source table
field 1
field 2
destination table
field to write