The number of columns shouldn't be changed. Only the number of rows which is equal to the number of products, right?
I'm not sure that I understand the problem...
Yes you are right, attached my table, but I'll explain only by two colonmns and two lines,
Product table ( when loaded by my customer number 1)
detergent 1 4 USD
detergent 2 3 USD
detergent 3 2 USD
Product table (same table) ( when loaded by my customer number 2)
Pillow 1 10 usd
Pillow 2 8 usd
Code to insert all the lines for the Product table ( when loaded by my customer number 1)
INSERT INTO Amir_Test3_SQL_Stock (Produit,Stock, Date) VALUES (
Code to insert all the lines for the Product table ( when loaded by my customer number 1)
INSERT INTO Amir_Test3_SQL_Stock (Produit,Stock, Date) VALUES (
As you can see the code changes depending on the number of the table lines, I want to have only one code for different lines!
I can send line by line using a for loop, but as I wrote in a different post, the problem is that if internet connection problem, some lines are sent and others no, while when I use insert for all the lines in the same time, I'll rather send all the lines or don't send anything!
Hope I could explain the problem
