Can you please help:
I have 2 mysql databases:
original_list
new_list
In both lists, the columns are "color", "item", and "price"
What is the script that will compare both databases, to find out which items in "new_list" are:
1.) RED
2.) NOT in "original_list"
and then will print out a list to a file all those items.
To clarify, here is an example sampling of both databases:
original_list database:
red apple
green tree
red car
blue sky
new_list database:
red apple
green tree
green car
red strawberry
red sky
The result I would want to see is:
red strawberry
red sky
I am hoping for some sort of script in the format of:
mysql_query = (select from new_list where (color == 'red') and not in old_list);
Thank you!!
p.s. I tried a "sub-sampling" suggestion from an earlier answer, but it didn't work.
