Bulk insert multiple records into an SQL table field2, where value matches ID from field1
We have an SQL database that contains a product catalogue of information. We have a team of people collecting additional information that we would like to insert into the database.
Our database table is called Products and within this table there is a unique numeric identifier field p_id and the associated content would need to be inserted into the field p_custom_content2 when the information to be inserted has a match on the value of p_id
What is the best way to save that additional information in the external datasource and how to import it in bulk?
For example, we are collecting html descriptions for products, so we could make an Excel spreadsheet file and have the p_id value in one column and the actual html to be inserted in a separate column called p_custom_content2 - would this work? Alternatively, we might decide on saving the additional data in its own MySQL database since excel spreadsheets are a bit clunky with multiple line html records. How can we regularly transfer the data from the external source into the main Products table?