Is it possible to write one table in one command?
I was doing some homeworks about SQL, and I wanted to know if I could optimized my time.
Ride-along:
select new_num, new_titre, new_texte, new_date,prf_nom, prf_prenom
from t_news_new
join t_compte_cpt using (cpt_pseudo)
join t_profil_prf using (cpt_pseudo)
limit 5;
In bold and italics, this is all the column from my table T_NEWS_NEW and prf_nom, prf_prenom are from another table. Is it to possible to use only one command instead of writing all the column of the table?
I know, we can use (*) to select all the column from a table but here prf_nom, prf_prenom are from another table and if I do a join, the (*) will be applied to the table that I joined but I only want prf_nom, prf_prenom.
Thank you for your help
mysql
edited Nov 21 '18 at 14:15
Hunter McMillen
36.3k1585143
asked Nov 21 '18 at 14:13
Axel.BAxel.B
1
add a comment |
I was doing some homeworks about SQL, and I wanted to know if I could optimized my time.
Ride-along:
select new_num, new_titre, new_texte, new_date,prf_nom, prf_prenom
from t_news_new
join t_compte_cpt using (cpt_pseudo)
join t_profil_prf using (cpt_pseudo)
limit 5;
In bold and italics, this is all the column from my table T_NEWS_NEW and prf_nom, prf_prenom are from another table. Is it to possible to use only one command instead of writing all the column of the table?
I know, we can use (*) to select all the column from a table but here prf_nom, prf_prenom are from another table and if I do a join, the (*) will be applied to the table that I joined but I only want prf_nom, prf_prenom.
Thank you for your help
mysql
edited Nov 21 '18 at 14:15
Hunter McMillen
36.3k1585143
asked Nov 21 '18 at 14:13
Axel.BAxel.B
1
To clarify, you are asking how to only selectprf_nomandprf_prenomand no other columns from the result of the join? Which table do each of those columns belong to?
– Hunter McMillen
Nov 21 '18 at 14:16
1
Alias each table separately. Now if (let say) the alias for other table ist2; you can useselect t2.*
– Madhur Bhaiya
Nov 21 '18 at 14:36
1
I triedt_news_new.*and it worked ! Thanks you @MadhurBhaiya , that was exactly what I wanted.
– Axel.B
Nov 22 '18 at 15:24
You can write the answer on what you finally did and mark it accepted for closure
– Madhur Bhaiya
Nov 22 '18 at 16:01
add a comment |
I was doing some homeworks about SQL, and I wanted to know if I could optimized my time.
Ride-along:
select new_num, new_titre, new_texte, new_date,prf_nom, prf_prenom
from t_news_new
join t_compte_cpt using (cpt_pseudo)
join t_profil_prf using (cpt_pseudo)
limit 5;
In bold and italics, this is all the column from my table T_NEWS_NEW and prf_nom, prf_prenom are from another table. Is it to possible to use only one command instead of writing all the column of the table?
I know, we can use (*) to select all the column from a table but here prf_nom, prf_prenom are from another table and if I do a join, the (*) will be applied to the table that I joined but I only want prf_nom, prf_prenom.
Thank you for your help
mysql
edited Nov 21 '18 at 14:15
Hunter McMillen
36.3k1585143
asked Nov 21 '18 at 14:13
Axel.BAxel.B
1
I was doing some homeworks about SQL, and I wanted to know if I could optimized my time.
Ride-along:
select new_num, new_titre, new_texte, new_date,prf_nom, prf_prenom
from t_news_new
join t_compte_cpt using (cpt_pseudo)
join t_profil_prf using (cpt_pseudo)
limit 5;
In bold and italics, this is all the column from my table T_NEWS_NEW and prf_nom, prf_prenom are from another table. Is it to possible to use only one command instead of writing all the column of the table?
I know, we can use (*) to select all the column from a table but here prf_nom, prf_prenom are from another table and if I do a join, the (*) will be applied to the table that I joined but I only want prf_nom, prf_prenom.
Thank you for your help
mysql
mysql
edited Nov 21 '18 at 14:15
Hunter McMillen
36.3k1585143
asked Nov 21 '18 at 14:13
Axel.BAxel.B
1
edited Nov 21 '18 at 14:15
Hunter McMillen
36.3k1585143
asked Nov 21 '18 at 14:13
Axel.BAxel.B
1
edited Nov 21 '18 at 14:15
Hunter McMillen
36.3k1585143
edited Nov 21 '18 at 14:15
Hunter McMillen
36.3k1585143
edited Nov 21 '18 at 14:15
Hunter McMillen
36.3k1585143
36.3k1585143
asked Nov 21 '18 at 14:13
Axel.BAxel.B
1
asked Nov 21 '18 at 14:13
Axel.BAxel.B
1
asked Nov 21 '18 at 14:13
Axel.BAxel.B
1
1
To clarify, you are asking how to only selectprf_nomandprf_prenomand no other columns from the result of the join? Which table do each of those columns belong to?
– Hunter McMillen
Nov 21 '18 at 14:16
1
Alias each table separately. Now if (let say) the alias for other table ist2; you can useselect t2.*
– Madhur Bhaiya
Nov 21 '18 at 14:36
1
I triedt_news_new.*and it worked ! Thanks you @MadhurBhaiya , that was exactly what I wanted.
– Axel.B
Nov 22 '18 at 15:24
You can write the answer on what you finally did and mark it accepted for closure
– Madhur Bhaiya
Nov 22 '18 at 16:01
add a comment |
To clarify, you are asking how to only selectprf_nomandprf_prenomand no other columns from the result of the join? Which table do each of those columns belong to?
– Hunter McMillen
Nov 21 '18 at 14:16
1
Alias each table separately. Now if (let say) the alias for other table ist2; you can useselect t2.*
– Madhur Bhaiya
Nov 21 '18 at 14:36
1
I triedt_news_new.*and it worked ! Thanks you @MadhurBhaiya , that was exactly what I wanted.
– Axel.B
Nov 22 '18 at 15:24
You can write the answer on what you finally did and mark it accepted for closure
– Madhur Bhaiya
Nov 22 '18 at 16:01
To clarify, you are asking how to only select
prf_nom and prf_prenom and no other columns from the result of the join? Which table do each of those columns belong to?– Hunter McMillen
Nov 21 '18 at 14:16
To clarify, you are asking how to only select
prf_nom and prf_prenom and no other columns from the result of the join? Which table do each of those columns belong to?– Hunter McMillen
Nov 21 '18 at 14:16
1
1
Alias each table separately. Now if (let say) the alias for other table is
t2; you can use select t2.*– Madhur Bhaiya
Nov 21 '18 at 14:36
Alias each table separately. Now if (let say) the alias for other table is
t2; you can use select t2.*– Madhur Bhaiya
Nov 21 '18 at 14:36
1
1
I tried
t_news_new.* and it worked ! Thanks you @MadhurBhaiya , that was exactly what I wanted.– Axel.B
Nov 22 '18 at 15:24
I tried
t_news_new.* and it worked ! Thanks you @MadhurBhaiya , that was exactly what I wanted.– Axel.B
Nov 22 '18 at 15:24
You can write the answer on what you finally did and mark it accepted for closure
– Madhur Bhaiya
Nov 22 '18 at 16:01
You can write the answer on what you finally did and mark it accepted for closure
– Madhur Bhaiya
Nov 22 '18 at 16:01
add a comment |
0
active
oldest
votes
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
});
}
});
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%2f53414007%2fis-it-possible-to-write-one-table-in-one-command%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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%2f53414007%2fis-it-possible-to-write-one-table-in-one-command%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
To clarify, you are asking how to only select
prf_nomandprf_prenomand no other columns from the result of the join? Which table do each of those columns belong to?– Hunter McMillen
Nov 21 '18 at 14:16
1
Alias each table separately. Now if (let say) the alias for other table is
t2; you can useselect t2.*– Madhur Bhaiya
Nov 21 '18 at 14:36
1
I tried
t_news_new.*and it worked ! Thanks you @MadhurBhaiya , that was exactly what I wanted.– Axel.B
Nov 22 '18 at 15:24
You can write the answer on what you finally did and mark it accepted for closure
– Madhur Bhaiya
Nov 22 '18 at 16:01