Mysql query for comparing two tables and another for updatin
Posted: Thu Aug 03, 2006 7:04 am
Hi
I have a mysql database for a price list from my supplier and I’m wanting a query to compare the current price list (table) to the new one, for new products
And also another one to update the prices
The current price list has a few new columns but the first columns is the same (part_number)
Can some one help me as I’m fairly new to mysql
Thanks
Clint
I have a mysql database for a price list from my supplier and I’m wanting a query to compare the current price list (table) to the new one, for new products
And also another one to update the prices
The current price list has a few new columns but the first columns is the same (part_number)
Can some one help me as I’m fairly new to mysql
Thanks
Clint