Mixing
Convert rows in columns
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
1
I have a problem with a table in my MYSQL database: my table is a 3-dimensional matrix, namely:
FormId, FieldName, FieldValue
160, TITLE, A
160, NAME, B
160, SURNAME, C
161, TITLE, D
161, NAME, E
161, SURNAME, F
162, TITLE, G
162, NAME, H
162, SURNAME, I
How can I get this result?
FormId, Title, Name, Surname
160, A, B, C
161, D, E, F
162, G, H, I
Thanks to all
mysql
asked Jan 3 at 9:53
CarmeloCarmelo
83
add a comment |
1
I have a problem with a table in my MYSQL database: my table is a 3-dimensional matrix, namely:
FormId, FieldName, FieldValue
160, TITLE, A
160, NAME, B
160, SURNAME, C
161, TITLE, D
161, NAME, E
161, SURNAME, F
162, TITLE, G
162, NAME, H
162, SURNAME, I
How can I get this result?
FormId, Title, Name, Surname
160, A, B, C
161, D, E, F
162, G, H, I
Thanks to all
mysql
asked Jan 3 at 9:53
CarmeloCarmelo
83
add a comment |
1
1
1
0
I have a problem with a table in my MYSQL database: my table is a 3-dimensional matrix, namely:
FormId, FieldName, FieldValue
160, TITLE, A
160, NAME, B
160, SURNAME, C
161, TITLE, D
161, NAME, E
161, SURNAME, F
162, TITLE, G
162, NAME, H
162, SURNAME, I
How can I get this result?
FormId, Title, Name, Surname
160, A, B, C
161, D, E, F
162, G, H, I
Thanks to all
mysql
asked Jan 3 at 9:53
CarmeloCarmelo
83
I have a problem with a table in my MYSQL database: my table is a 3-dimensional matrix, namely:
FormId, FieldName, FieldValue
160, TITLE, A
160, NAME, B
160, SURNAME, C
161, TITLE, D
161, NAME, E
161, SURNAME, F
162, TITLE, G
162, NAME, H
162, SURNAME, I
How can I get this result?
FormId, Title, Name, Surname
160, A, B, C
161, D, E, F
162, G, H, I
Thanks to all
mysql
mysql
asked Jan 3 at 9:53
CarmeloCarmelo
83
asked Jan 3 at 9:53
CarmeloCarmelo
83
asked Jan 3 at 9:53
CarmeloCarmelo
83
asked Jan 3 at 9:53
CarmeloCarmelo
83
asked Jan 3 at 9:53
CarmeloCarmelo
83
83
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
0
You can try below - using case when expression
select FormId, max(case when FieldName='Title' then FieldValue end) as Title,
max(case when FieldName='Name' then FieldValue end) as Name,
max(case when ieldName='Surname' then FieldValue end) as Surname
from tablename
group by FormId
answered Jan 3 at 9:58
fa06fa06
19.1k21019
add a comment |
0
you can join three tables, and select one column from each table
select t1.FormId, t1.FieldValue Title, t2.FieldValue Name, t3.FieldValue Surname
from tname t1 inner join tname t2
on t1.FormId = t2.FormId
inner join tname t3
on t2.FormId = t3.FormId
where t1.FieldName = TITLE
and t2.FieldName = NAME
and t3.FieldName = SURNAME
answered Jan 3 at 10:35
ssynhtnssynhtn
193211
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54019864%2fconvert-rows-in-columns%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
You can try below - using case when expression
select FormId, max(case when FieldName='Title' then FieldValue end) as Title,
max(case when FieldName='Name' then FieldValue end) as Name,
max(case when ieldName='Surname' then FieldValue end) as Surname
from tablename
group by FormId
answered Jan 3 at 9:58
fa06fa06
19.1k21019
add a comment |
0
You can try below - using case when expression
select FormId, max(case when FieldName='Title' then FieldValue end) as Title,
max(case when FieldName='Name' then FieldValue end) as Name,
max(case when ieldName='Surname' then FieldValue end) as Surname
from tablename
group by FormId
answered Jan 3 at 9:58
fa06fa06
19.1k21019
add a comment |
0
0
0
You can try below - using case when expression
select FormId, max(case when FieldName='Title' then FieldValue end) as Title,
max(case when FieldName='Name' then FieldValue end) as Name,
max(case when ieldName='Surname' then FieldValue end) as Surname
from tablename
group by FormId
answered Jan 3 at 9:58
fa06fa06
19.1k21019
You can try below - using case when expression
select FormId, max(case when FieldName='Title' then FieldValue end) as Title,
max(case when FieldName='Name' then FieldValue end) as Name,
max(case when ieldName='Surname' then FieldValue end) as Surname
from tablename
group by FormId
answered Jan 3 at 9:58
fa06fa06
19.1k21019
answered Jan 3 at 9:58
fa06fa06
19.1k21019
answered Jan 3 at 9:58
fa06fa06
19.1k21019
answered Jan 3 at 9:58
fa06fa06
19.1k21019
19.1k21019
add a comment |
add a comment |
0
you can join three tables, and select one column from each table
select t1.FormId, t1.FieldValue Title, t2.FieldValue Name, t3.FieldValue Surname
from tname t1 inner join tname t2
on t1.FormId = t2.FormId
inner join tname t3
on t2.FormId = t3.FormId
where t1.FieldName = TITLE
and t2.FieldName = NAME
and t3.FieldName = SURNAME
answered Jan 3 at 10:35
ssynhtnssynhtn
193211
add a comment |
0
you can join three tables, and select one column from each table
select t1.FormId, t1.FieldValue Title, t2.FieldValue Name, t3.FieldValue Surname
from tname t1 inner join tname t2
on t1.FormId = t2.FormId
inner join tname t3
on t2.FormId = t3.FormId
where t1.FieldName = TITLE
and t2.FieldName = NAME
and t3.FieldName = SURNAME
answered Jan 3 at 10:35
ssynhtnssynhtn
193211
add a comment |
0
0
0
you can join three tables, and select one column from each table
select t1.FormId, t1.FieldValue Title, t2.FieldValue Name, t3.FieldValue Surname
from tname t1 inner join tname t2
on t1.FormId = t2.FormId
inner join tname t3
on t2.FormId = t3.FormId
where t1.FieldName = TITLE
and t2.FieldName = NAME
and t3.FieldName = SURNAME
answered Jan 3 at 10:35
ssynhtnssynhtn
193211
you can join three tables, and select one column from each table
select t1.FormId, t1.FieldValue Title, t2.FieldValue Name, t3.FieldValue Surname
from tname t1 inner join tname t2
on t1.FormId = t2.FormId
inner join tname t3
on t2.FormId = t3.FormId
where t1.FieldName = TITLE
and t2.FieldName = NAME
and t3.FieldName = SURNAME
answered Jan 3 at 10:35
ssynhtnssynhtn
193211
answered Jan 3 at 10:35
ssynhtnssynhtn
193211
answered Jan 3 at 10:35
ssynhtnssynhtn
193211
answered Jan 3 at 10:35
ssynhtnssynhtn
193211
193211
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54019864%2fconvert-rows-in-columns%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
