Mysql single values from a table insert into a new table

Question

I have a big issue, because I don't know how I can put a singles Value from a table into a new table. Here are the construct of the invoice, how I upload it:

Edit: I give the comment below right, you need more information. I tell you my steps:

The values I need for my work are in a invoice, so I upload this invoice in my database. In the first screenshot you will see the only the construct of the invoice. The values stand for price and a item number. But I need only the prices and the item number. So I have to put these three value in a new table

This is my goal:

Do you feel your question is brief enough for others to answer? — Viki888, Nov 23 '16 at 11:01
From your requirement, basically you are trying to achieve PIVOT. Have a look on this thread. http://stackoverflow.com/questions/7674786/mysql-pivot-table — Viki888, Nov 23 '16 at 12:08

score -1 · Answer 1 · answered Nov 23 '16 at 11:01

-1

 insert into table_1(col1,col2,col3,col4)
 select value1 as col1, value2 as col2, value3 as col3, value4 as col4 from table_2

Make sure the columns names of table_2 much match the columns names of table1 (in which you are inserting the values)

answered Nov 23 '16 at 11:01

Danyal Sandeelo

12,196
10
47
78

Thank you for your help, but it was my fall. I doesn't give you the informationens you need. – Marcello Nov 23 '16 at 11:16
Table1 has the details, and I want to put it in table2. Thank you for your help – Marcello Nov 23 '16 at 11:23
then select columns from table1 and add in table2, just modify the above query as per your needs – Danyal Sandeelo Nov 23 '16 at 11:24
okay, how can i get the scond price in the first row ? this is the main problem I think to get itemnumber-price1-price2 – Marcello Nov 23 '16 at 12:19

Mysql single values from a table insert into a new table

1 Answers1