I need a solution for this situation:
I have 2 SQL databases which are hosted on the same server. Using data from database 1, I need to see and change values to database 2.
Database 1 has 1 table with 2 columns: item_id, item_name
Database 2 has 1 table with 4 columns: model, quantity, stock, shipping_time
By using the data from database 1 I want to be able to change the STOCK values to database 2. The change should be easy to make, via jquery. The other columns should remain untouched.
Column "item_id" from database 1 is exactly the same with the column "model" from database 2.
Hello, My name is Lakhan, I have a vast working experience in website development and i will do your work Connect 2 databases and display the data. Thanks
39 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hello sir, I would like to work on your Database project. I will do this by using store procedure or using trigger. Expertise: MySQL, Database Administration, MySQL server configuration Thanks Chitano