Results 1 to 3 of 3
Apr 21, 2010, 08:08 #1
Sending multiple fields per product to new table
I have a table of products called 'products' like:
| id | name | desc | price | supplierId | barcode1 | barcode2 | barcode3 | barcode4 | etc.........
Some products have as many as 10 different barcodes. Obviously this is a ridiculous setup of barcodes (imported from supplier price lists) which I would like send to their own table called 'barcodes' like:
| productId | barcode |
(where productId is matched to that in the 'products' table - products.id)
Then each barcode can be slit into their own entries.
Thing is I have thousands of products. Any idea on how I can do this in bulk? I don't really know where to start!
Apr 21, 2010, 09:13 #2Guido - Community Team Leader
The Votes Are In: The Winners of the 2013 Community Awards are...
Blog - Free Flash Slideshow Widget
Apr 21, 2010, 11:37 #3
Excellent, cheers guido!