Mixing
Is there a possible way to have a row from a meta data table with a certain meta key automatically inserted...
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I currently have a MYSQL query that searches a usermeta table and matches emails up with customer emails from another table, then creates a row in the usermeta table with the corresponding customer id. However, is there a way to have this done automatically every time these types of rows are inserted into the customer table?
Or at the very least, is there a way to send ALL rows from one table to the other automatically with the emails being what the two tables share in common, then after it matches the email it assigns the correct user id based on the userdata table?
mysql join hyperlink automation
edited Jan 3 at 7:47
Brian Tompsett - 汤莱恩
4,2521339103
asked Jan 3 at 4:51
DanDan
32
add a comment |
I currently have a MYSQL query that searches a usermeta table and matches emails up with customer emails from another table, then creates a row in the usermeta table with the corresponding customer id. However, is there a way to have this done automatically every time these types of rows are inserted into the customer table?
Or at the very least, is there a way to send ALL rows from one table to the other automatically with the emails being what the two tables share in common, then after it matches the email it assigns the correct user id based on the userdata table?
mysql join hyperlink automation
edited Jan 3 at 7:47
Brian Tompsett - 汤莱恩
4,2521339103
asked Jan 3 at 4:51
DanDan
32
Can you please edit your post and show the schema of yourusermetatable and theother_table? Please also add examples of the data you have and the data you want. It shouldn't be hard to create the appropriate database trigger or aninsertorupdatestatement, but without the information about the tables we can't help you here.
– Corion
Jan 3 at 9:15
You can use triggers do run code when you insert/update/delete rows, andinsert ... selectto insert lots of rows (that you are able to write a select for) at once into a table. To get a more precise answer, you would need to add your current code, table and sample data and expected result. In general you should make sure you are not getting in trouble duplicating data (e.g. check what happens if the email in the original table changes after you created metadata)
– Solarflare
Jan 3 at 9:15
add a comment |
I currently have a MYSQL query that searches a usermeta table and matches emails up with customer emails from another table, then creates a row in the usermeta table with the corresponding customer id. However, is there a way to have this done automatically every time these types of rows are inserted into the customer table?
Or at the very least, is there a way to send ALL rows from one table to the other automatically with the emails being what the two tables share in common, then after it matches the email it assigns the correct user id based on the userdata table?
mysql join hyperlink automation
edited Jan 3 at 7:47
Brian Tompsett - 汤莱恩
4,2521339103
asked Jan 3 at 4:51
DanDan
32
I currently have a MYSQL query that searches a usermeta table and matches emails up with customer emails from another table, then creates a row in the usermeta table with the corresponding customer id. However, is there a way to have this done automatically every time these types of rows are inserted into the customer table?
Or at the very least, is there a way to send ALL rows from one table to the other automatically with the emails being what the two tables share in common, then after it matches the email it assigns the correct user id based on the userdata table?
mysql join hyperlink automation
mysql join hyperlink automation
edited Jan 3 at 7:47
Brian Tompsett - 汤莱恩
4,2521339103
asked Jan 3 at 4:51
DanDan
32
edited Jan 3 at 7:47
Brian Tompsett - 汤莱恩
4,2521339103
asked Jan 3 at 4:51
DanDan
32
edited Jan 3 at 7:47
Brian Tompsett - 汤莱恩
4,2521339103
edited Jan 3 at 7:47
Brian Tompsett - 汤莱恩
4,2521339103
edited Jan 3 at 7:47
Brian Tompsett - 汤莱恩
4,2521339103
4,2521339103
asked Jan 3 at 4:51
DanDan
32
asked Jan 3 at 4:51
DanDan
32
asked Jan 3 at 4:51
DanDan
32
32
Can you please edit your post and show the schema of yourusermetatable and theother_table? Please also add examples of the data you have and the data you want. It shouldn't be hard to create the appropriate database trigger or aninsertorupdatestatement, but without the information about the tables we can't help you here.
– Corion
Jan 3 at 9:15
You can use triggers do run code when you insert/update/delete rows, andinsert ... selectto insert lots of rows (that you are able to write a select for) at once into a table. To get a more precise answer, you would need to add your current code, table and sample data and expected result. In general you should make sure you are not getting in trouble duplicating data (e.g. check what happens if the email in the original table changes after you created metadata)
– Solarflare
Jan 3 at 9:15
add a comment |
Can you please edit your post and show the schema of yourusermetatable and theother_table? Please also add examples of the data you have and the data you want. It shouldn't be hard to create the appropriate database trigger or aninsertorupdatestatement, but without the information about the tables we can't help you here.
– Corion
Jan 3 at 9:15
You can use triggers do run code when you insert/update/delete rows, andinsert ... selectto insert lots of rows (that you are able to write a select for) at once into a table. To get a more precise answer, you would need to add your current code, table and sample data and expected result. In general you should make sure you are not getting in trouble duplicating data (e.g. check what happens if the email in the original table changes after you created metadata)
– Solarflare
Jan 3 at 9:15
Can you please edit your post and show the schema of your
usermeta table and the other_table? Please also add examples of the data you have and the data you want. It shouldn't be hard to create the appropriate database trigger or an insert or update statement, but without the information about the tables we can't help you here.– Corion
Jan 3 at 9:15
Can you please edit your post and show the schema of your
usermeta table and the other_table? Please also add examples of the data you have and the data you want. It shouldn't be hard to create the appropriate database trigger or an insert or update statement, but without the information about the tables we can't help you here.– Corion
Jan 3 at 9:15
You can use triggers do run code when you insert/update/delete rows, and
insert ... select to insert lots of rows (that you are able to write a select for) at once into a table. To get a more precise answer, you would need to add your current code, table and sample data and expected result. In general you should make sure you are not getting in trouble duplicating data (e.g. check what happens if the email in the original table changes after you created metadata)– Solarflare
Jan 3 at 9:15
You can use triggers do run code when you insert/update/delete rows, and
insert ... select to insert lots of rows (that you are able to write a select for) at once into a table. To get a more precise answer, you would need to add your current code, table and sample data and expected result. In general you should make sure you are not getting in trouble duplicating data (e.g. check what happens if the email in the original table changes after you created metadata)– Solarflare
Jan 3 at 9:15
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%2f54016521%2fis-there-a-possible-way-to-have-a-row-from-a-meta-data-table-with-a-certain-meta%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%2f54016521%2fis-there-a-possible-way-to-have-a-row-from-a-meta-data-table-with-a-certain-meta%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
Can you please edit your post and show the schema of your
usermetatable and theother_table? Please also add examples of the data you have and the data you want. It shouldn't be hard to create the appropriate database trigger or aninsertorupdatestatement, but without the information about the tables we can't help you here.– Corion
Jan 3 at 9:15
You can use triggers do run code when you insert/update/delete rows, and
insert ... selectto insert lots of rows (that you are able to write a select for) at once into a table. To get a more precise answer, you would need to add your current code, table and sample data and expected result. In general you should make sure you are not getting in trouble duplicating data (e.g. check what happens if the email in the original table changes after you created metadata)– Solarflare
Jan 3 at 9:15