How do I name a query table in mysql?
Let's assume I do a very simple query selecting 2 columns out of the 5 columns in a table. How do I name the query table for future use?
Sorry for asking something that sounds so obvious but have looked for answer everywhere and could not find any.
mysql
asked Jul 13 '15 at 8:44
LaurentLaurent
62
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
Let's assume I do a very simple query selecting 2 columns out of the 5 columns in a table. How do I name the query table for future use?
Sorry for asking something that sounds so obvious but have looked for answer everywhere and could not find any.
mysql
asked Jul 13 '15 at 8:44
LaurentLaurent
62
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
1
It's not clear what you mean. Perhaps aView? Or a prepared statement?
– ypercubeᵀᴹ
Jul 13 '15 at 8:48
Name itthe_2_out_of_5_columns_view_from_table_whatever. Always go for the name, that best describes its content!
– tombom
Jul 13 '15 at 9:01
add a comment |
Let's assume I do a very simple query selecting 2 columns out of the 5 columns in a table. How do I name the query table for future use?
Sorry for asking something that sounds so obvious but have looked for answer everywhere and could not find any.
mysql
asked Jul 13 '15 at 8:44
LaurentLaurent
62
Let's assume I do a very simple query selecting 2 columns out of the 5 columns in a table. How do I name the query table for future use?
Sorry for asking something that sounds so obvious but have looked for answer everywhere and could not find any.
mysql
mysql
asked Jul 13 '15 at 8:44
LaurentLaurent
62
asked Jul 13 '15 at 8:44
LaurentLaurent
62
asked Jul 13 '15 at 8:44
LaurentLaurent
62
asked Jul 13 '15 at 8:44
LaurentLaurent
62
asked Jul 13 '15 at 8:44
LaurentLaurent
62
62
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
1
It's not clear what you mean. Perhaps aView? Or a prepared statement?
– ypercubeᵀᴹ
Jul 13 '15 at 8:48
Name itthe_2_out_of_5_columns_view_from_table_whatever. Always go for the name, that best describes its content!
– tombom
Jul 13 '15 at 9:01
add a comment |
1
It's not clear what you mean. Perhaps aView? Or a prepared statement?
– ypercubeᵀᴹ
Jul 13 '15 at 8:48
Name itthe_2_out_of_5_columns_view_from_table_whatever. Always go for the name, that best describes its content!
– tombom
Jul 13 '15 at 9:01
1
1
It's not clear what you mean. Perhaps a
View? Or a prepared statement?– ypercubeᵀᴹ
Jul 13 '15 at 8:48
It's not clear what you mean. Perhaps a
View? Or a prepared statement?– ypercubeᵀᴹ
Jul 13 '15 at 8:48
Name it
the_2_out_of_5_columns_view_from_table_whatever. Always go for the name, that best describes its content!– tombom
Jul 13 '15 at 9:01
Name it
the_2_out_of_5_columns_view_from_table_whatever. Always go for the name, that best describes its content!– tombom
Jul 13 '15 at 9:01
add a comment |
1 Answer
1
active
oldest
votes
A view would allow you to group columns from different tables so you can view that data all at once.
An example would be if you had a SALES view to report on
you would create the SALES VIEW by joining a Customer table so you can see who purchased the item, you would also include a Inventory, or Items table so you can see the details of the item purchase.
So next time you need to query which customer bought which item, you would just query against the view that would contain all the columns you need
answered Jul 13 '15 at 14:51
HectorHector
8841620
add a comment |
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f106735%2fhow-do-i-name-a-query-table-in-mysql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
A view would allow you to group columns from different tables so you can view that data all at once.
An example would be if you had a SALES view to report on
you would create the SALES VIEW by joining a Customer table so you can see who purchased the item, you would also include a Inventory, or Items table so you can see the details of the item purchase.
So next time you need to query which customer bought which item, you would just query against the view that would contain all the columns you need
answered Jul 13 '15 at 14:51
HectorHector
8841620
add a comment |
A view would allow you to group columns from different tables so you can view that data all at once.
An example would be if you had a SALES view to report on
you would create the SALES VIEW by joining a Customer table so you can see who purchased the item, you would also include a Inventory, or Items table so you can see the details of the item purchase.
So next time you need to query which customer bought which item, you would just query against the view that would contain all the columns you need
answered Jul 13 '15 at 14:51
HectorHector
8841620
add a comment |
A view would allow you to group columns from different tables so you can view that data all at once.
An example would be if you had a SALES view to report on
you would create the SALES VIEW by joining a Customer table so you can see who purchased the item, you would also include a Inventory, or Items table so you can see the details of the item purchase.
So next time you need to query which customer bought which item, you would just query against the view that would contain all the columns you need
answered Jul 13 '15 at 14:51
HectorHector
8841620
A view would allow you to group columns from different tables so you can view that data all at once.
An example would be if you had a SALES view to report on
you would create the SALES VIEW by joining a Customer table so you can see who purchased the item, you would also include a Inventory, or Items table so you can see the details of the item purchase.
So next time you need to query which customer bought which item, you would just query against the view that would contain all the columns you need
answered Jul 13 '15 at 14:51
HectorHector
8841620
answered Jul 13 '15 at 14:51
HectorHector
8841620
answered Jul 13 '15 at 14:51
HectorHector
8841620
answered Jul 13 '15 at 14:51
HectorHector
8841620
8841620
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f106735%2fhow-do-i-name-a-query-table-in-mysql%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
1
It's not clear what you mean. Perhaps a
View? Or a prepared statement?– ypercubeᵀᴹ
Jul 13 '15 at 8:48
Name it
the_2_out_of_5_columns_view_from_table_whatever. Always go for the name, that best describes its content!– tombom
Jul 13 '15 at 9:01