Hi am trying to duplicate the entire content of a table into the same table but adding the prefix "A_" in front of the new data. With this i will have the same data twice but one with the "A-" all in the same table.
I need to do this because we need to control the inventory of the different shops and the software we are using does not allow us to do so. By add the prefix "A-" in front we can control two diffrent inventory with the same software.
smarier, you do not need to duplicate the stock to cover 2 shops, you use a Many to Many table that relates the stock to the Shop and contains the Quantity for that shop. ie
ID 1 Sugar 1KG Bag
ID 2 Tea 1KG box
ID 1 shop 1
ID 2 shop 2
Shop ID 1 - Stock ID 1 - Quantity 100
Shop ID 2 - Stock ID 1 - Quantity 20
Shop ID 1 - Stock ID 2 -Quantity 25
Shop ID 2 - Stock ID 2 -Quantity 1
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!