Test your restores, not your backups...

Bill Prew

Network Development Engineer

Steve Jennings

<div>
<p>Thanks Chris . . .I will try that now. They say they only need to add data to a row, and NOT delete.</p><p><br></p><p>Steve</p>
</div>


Thanks Chris . . .I will try that now. They say they only need to add data to a row, and NOT delete.




Steve

<div>
<div class="content wysiwyg-content">
I have a table of devices:<br />
<br />
NET_TABLE: vendor - model - location - name - contract - owner (plus about 30 more columns)<br />
<br />
The ops team copies that table removes some columns and creates more columns:<br />
<br />
OPS_TABLE: vendor - model - location - name - notes - engineer - customer (plus about 40 more columns)<br />
<br />
Whenever I add a new device (row) the ops team has to copy the new table and go thru a cumbersome process to keep their data.<br />
<br />
This seems really inefficient. I don't really want to populate my table with their columns.<br />
<br />
I'm thinking there must be a way to &quot;union&quot; or &quot;join&quot; my table with their table to pick up only new &quot;vendor - model - location - name&quot; rows, but I can't figure out the syntax to do it.<br />
<br />
&quot;union&quot; seems to want a matching number of columns, and &quot;join&quot; seems only to find commonalities.<br />
<br />
I can't seem to wrap my head around how to solve this, but it seems like a really simple problem.<br />
<br />
SteveJ
</div>
</div>


I have a table of devices:

NET_TABLE: vendor - model - location - name - contract - owner (plus about 30 more columns)

The ops team copies that table removes some columns and creates more columns:

OPS_TABLE: vendor - model - location - name - notes - engineer - customer (plus about 40 more columns)

Whenever I add a new device (row) the ops team has to copy the new table and go thru a cumbersome process to keep their data.

This seems really inefficient. I don't really want to populate my table with their columns.

I'm thinking there must be a way to "union" or "join" my table with their table to pick up only new "vendor - model - location - name" rows, but I can't figure out the syntax to do it.

"union" seems to want a matching number of columns, and "join" seems only to find commonalities.

I can't seem to wrap my head around how to solve this, but it seems like a really simple problem.

SteveJ

How to join/merge/union 2 tables so that new rows from one will be available in the other

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.