Re: merging tables

[Walter deMilly]

Thank you. I use Workbench for MySql but I'm a total novice. I looked around in the menu items, table inspector etc but I couldn't find a "Show Create Tables"

Can you tell me how to extract that info along with merge (or DO NOT INSERT) criterion?

I do have some information which may answer some of your other questions.

Table 1 has about 35,000 rows.
Table 2 has about 170 rows.

I have about 100 such tables.

Both tables have 3, identically named columns:

TIME_ VALUE_ WEEK_DAY

The "type" for each of these columns is the same:

varchar(30)

The nullable value for TIME_ is NO
The nullable value for VALUE_ is YES
The nullable value for WEEK_DAY_ is YES


CharacterSet for all is is latin1

Collation for all is latin1_swedish-d


Below I have extracted CSV files for the two tables.

Table 1:

TIME_ VALUE_ WEEK_DAY
12/21/2017 3:00 11 3
12/21/2017 4:00 11 3
12/21/2017 5:00 14 3
12/21/2017 6:00 22 3
12/21/2017 7:00 33 3
12/21/2017 8:00 46 3
12/21/2017 9:00 67 3


Table 2

TIME_ VALUE_ WEEK_DAY
11/30/2017 17:00 71 3
11/30/2017 18:00 63 3
11/30/2017 19:00 55 3
11/30/2017 20:00 47 3
11/30/2017 21:00 38 3
11/30/2017 22:00 36 3