How do I name a query table in mysql? The Next CEO of Stack OverflowHow to check the...
Is it professional to write unrelated content in an almost-empty email?
From jafe to El-Guest
How to avoid supervisors with prejudiced views?
Help! I cannot understand this game’s notations!
Lucky Feat: How can "more than one creature spend a luck point to influence the outcome of a roll"?
how one can write a nice vector parser, something that does pgfvecparse{A=B-C; D=E x F;}
Towers in the ocean; How deep can they be built?
Could a dragon use its wings to swim?
Why am I getting "Static method cannot be referenced from a non static context: String String.valueOf(Object)"?
Is a distribution that is normal, but highly skewed, considered Gaussian?
Free fall ellipse or parabola?
Why is the US ranked as #45 in Press Freedom ratings, despite its extremely permissive free speech laws?
How to get the last not-null value in an ordered column of a huge table?
Why don't programming languages automatically manage the synchronous/asynchronous problem?
How to use ReplaceAll on an expression that contains a rule
It is correct to match light sources with the same color temperature?
What does "shotgun unity" refer to here in this sentence?
Ising model simulation
Calculate the Mean mean of two numbers
How did Beeri the Hittite come up with naming his daughter Yehudit?
Is there a reasonable and studied concept of reduction between regular languages?
What flight has the highest ratio of timezone difference to flight time?
How do I fit a non linear curve?
Is there a way to save my career from absolute disaster?
How do I name a query table in mysql?
The Next CEO of Stack OverflowHow to check the consistency of tables in mysqlMySQL optimization question — how to speed up a simple queryHow do I use subquery on the same table in MySQL?MySQL query conditional return using TRIM()Query condtion for values not being the default value?Issues with mysql enterprise backup, assertion failure on restoreHow to use COUNT with multiple columns?Anything obvious in optimization missed in my left join query?Large table load slow mysql php high resources usageMySQL query comparing table against itself is not utilizing index
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♦ 7 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♦ 7 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♦ 7 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♦ 7 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