SQL QUERY - ROWS TO COLUMN AND UPDATE

Question

enter image description here

Hello everyone,

1/ I want to do a sql query that transform the result from row to column like it's shown in the picture. Is it possible ?

2/ How can I update the second table with the first one ?

Does this answer your question? [MySQL - turn table into different table](https://stackoverflow.com/questions/15184381/mysql-turn-table-into-different-table) — nbk, Oct 08 '20 at 15:10
if you have a static column count see the duplicate, if the count is dynamic you have to use INFORMATION SCHEMA.columns for that and program it — nbk, Oct 08 '20 at 15:11

score 0 · Accepted Answer · answered Oct 08 '20 at 15:09

0

You could use in the query

select 'EH545WL' as name, EH545WL as value from car union select 'FJ281TJ' as name, FJ281TJ as value from car;

If you use this query, you could get the result you want. Thank you

answered Oct 08 '20 at 15:09

Great Coder

Priyanka2304 · Answer 2 · 2020-10-09T21:41:20.663

0

There are several ways that you can transform this data.

Create Table:

CREATE TABLE yourTable([EH545WL] varchar(10), [FJ281TJ] varchar(10));

INSERT INTO yourTable
VALUES
    (0,0);

Unpivot table:

SELECT ID,Value
FROM yourTable
UNPIVOT (value for ID in ([EH545WL],[FJ281TJ])) up

edited Oct 09 '20 at 21:41

answered Oct 08 '20 at 15:43

Priyanka2304

Okay thank you very much ! One more question is that how can I update the second table with the first one ? – Julie Tarnaud Oct 09 '20 at 13:21
@JulieTarnaud One thing you can do is after you get the desired output, drop the first table. Also please upvote/accept the answer if it works for you. – Priyanka2304 Oct 09 '20 at 17:22
I don't see your point. Because I need first table to update the second but I don't know how to realize the update – Julie Tarnaud Oct 09 '20 at 19:01
@JulieTarnaud Please see the updated sql code that lets you create table and update the same table in unpivot mode. – Priyanka2304 Oct 09 '20 at 21:42

2 Answers2