INSERT INTO or UpdateCan I concatenate multiple MySQL rows into one field?“INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”How to 'insert if not exists' in MySQL?INSERT INTO … SELECT FROM … ON DUPLICATE KEY UPDATEHow to import CSV file to MySQL tableInsert into a MySQL table or update if existsmysql -> insert into tbl (select from another table) and some default valuesSQL query return data from multiple tablesInsert if DNE else update Mysql rowHow get selected rows where user id is not in table record mysql
I have found a mistake on someone's code published online: what is the protocol?
Locked-up DOS computer beeped on keypress. What mechanism caused that?
Proof that every field is perfect???
How to prove that the covariant derivative obeys the product rule
Why aren't there any women super GMs?
Why did my "seldom" get corrected?
Inscriptio Labyrinthica
What would be the safest way to drop thousands of small, hard objects from a typical, high wing, GA airplane?
Why do the digits of a number squared follow a similar quotient?
How can I automate this tensor computation?
Random piece of plastic
Why is Google approaching my VPS machine?
How can I help our ranger feel special about her beast companion?
Three Subway Escalators
🍩🔔🔥Scrambled emoji tale⚛️🎶🛒 #2️⃣
What is this green alien supposed to be on the American covers of the "Hitchhiker's Guide to the Galaxy"?
How many opportunity attacks can you make per turn before becoming exhausted?
How to tell if JDK is available from within running JVM?
How did J. J. Thomson establish the particle nature of the electron?
Can error correction and detection be done without adding extra bits?
Demographic consequences of closed loop reincarnation
Changing iteration variable in Do loop
How important are the Author's mood and feelings for writing a story?
Did Hitler say this quote about homeschooling?
INSERT INTO or Update
Can I concatenate multiple MySQL rows into one field?“INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”How to 'insert if not exists' in MySQL?INSERT INTO … SELECT FROM … ON DUPLICATE KEY UPDATEHow to import CSV file to MySQL tableInsert into a MySQL table or update if existsmysql -> insert into tbl (select from another table) and some default valuesSQL query return data from multiple tablesInsert if DNE else update Mysql rowHow get selected rows where user id is not in table record mysql
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
My code updates same row multiple times in one query with values from another table. How to update or create a new record in one query? How to do that if there is no record "forum_users_posts_in" with matching data
userid
idcat
idcustom
create a new record (t.posts = 1)
If such a record exists then update it only (t.posts = t2.sum_total)
UPDATE #__forum_users_posts_in AS t
JOIN (
SELECT
userid, count(*) AS sum_total
FROM
#__forum_messages AS t2
WHERE
T2.thread = '.$topicId.' and hold = 0
GROUP BY
t2.userid
) AS t2 ON t.userid = t2.userid and (idcat = '.$cat->id.' or idcustom = '.$selectcustom1.')
SET t.posts = t.posts + t2.sum_total
php mysql insert-into
edited Mar 26 at 10:57
Jay Blanchard
36.4k12 gold badges57 silver badges100 bronze badges
asked Mar 26 at 10:52
waxmanwaxman
31 bronze badge
add a comment |
My code updates same row multiple times in one query with values from another table. How to update or create a new record in one query? How to do that if there is no record "forum_users_posts_in" with matching data
userid
idcat
idcustom
create a new record (t.posts = 1)
If such a record exists then update it only (t.posts = t2.sum_total)
UPDATE #__forum_users_posts_in AS t
JOIN (
SELECT
userid, count(*) AS sum_total
FROM
#__forum_messages AS t2
WHERE
T2.thread = '.$topicId.' and hold = 0
GROUP BY
t2.userid
) AS t2 ON t.userid = t2.userid and (idcat = '.$cat->id.' or idcustom = '.$selectcustom1.')
SET t.posts = t.posts + t2.sum_total
php mysql insert-into
edited Mar 26 at 10:57
Jay Blanchard
36.4k12 gold badges57 silver badges100 bronze badges
asked Mar 26 at 10:52
waxmanwaxman
31 bronze badge
add a comment |
My code updates same row multiple times in one query with values from another table. How to update or create a new record in one query? How to do that if there is no record "forum_users_posts_in" with matching data
userid
idcat
idcustom
create a new record (t.posts = 1)
If such a record exists then update it only (t.posts = t2.sum_total)
UPDATE #__forum_users_posts_in AS t
JOIN (
SELECT
userid, count(*) AS sum_total
FROM
#__forum_messages AS t2
WHERE
T2.thread = '.$topicId.' and hold = 0
GROUP BY
t2.userid
) AS t2 ON t.userid = t2.userid and (idcat = '.$cat->id.' or idcustom = '.$selectcustom1.')
SET t.posts = t.posts + t2.sum_total
php mysql insert-into
edited Mar 26 at 10:57
Jay Blanchard
36.4k12 gold badges57 silver badges100 bronze badges
asked Mar 26 at 10:52
waxmanwaxman
31 bronze badge
My code updates same row multiple times in one query with values from another table. How to update or create a new record in one query? How to do that if there is no record "forum_users_posts_in" with matching data
userid
idcat
idcustom
create a new record (t.posts = 1)
If such a record exists then update it only (t.posts = t2.sum_total)
UPDATE #__forum_users_posts_in AS t
JOIN (
SELECT
userid, count(*) AS sum_total
FROM
#__forum_messages AS t2
WHERE
T2.thread = '.$topicId.' and hold = 0
GROUP BY
t2.userid
) AS t2 ON t.userid = t2.userid and (idcat = '.$cat->id.' or idcustom = '.$selectcustom1.')
SET t.posts = t.posts + t2.sum_total
php mysql insert-into
php mysql insert-into
edited Mar 26 at 10:57
Jay Blanchard
36.4k12 gold badges57 silver badges100 bronze badges
asked Mar 26 at 10:52
waxmanwaxman
31 bronze badge
edited Mar 26 at 10:57
Jay Blanchard
36.4k12 gold badges57 silver badges100 bronze badges
asked Mar 26 at 10:52
waxmanwaxman
31 bronze badge
edited Mar 26 at 10:57
Jay Blanchard
36.4k12 gold badges57 silver badges100 bronze badges
edited Mar 26 at 10:57
Jay Blanchard
36.4k12 gold badges57 silver badges100 bronze badges
edited Mar 26 at 10:57
Jay Blanchard
36.4k12 gold badges57 silver badges100 bronze badges
36.4k12 gold badges57 silver badges100 bronze badges
asked Mar 26 at 10:52
waxmanwaxman
31 bronze badge
asked Mar 26 at 10:52
waxmanwaxman
31 bronze badge
asked Mar 26 at 10:52
waxmanwaxman
31 bronze badge
31 bronze badge
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You can try this method to create or edit row
INSERT INTO `table` (`columns`) VALUES
(...)
ON DUPLICATE KEY UPDATE
`column` = VALUES (`column`);
answered Mar 26 at 11:00
SonOfWinterSonOfWinter
336 bronze badges
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
);
);
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%2f55355349%2finsert-into-or-update%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
You can try this method to create or edit row
INSERT INTO `table` (`columns`) VALUES
(...)
ON DUPLICATE KEY UPDATE
`column` = VALUES (`column`);
answered Mar 26 at 11:00
SonOfWinterSonOfWinter
336 bronze badges
add a comment |
You can try this method to create or edit row
INSERT INTO `table` (`columns`) VALUES
(...)
ON DUPLICATE KEY UPDATE
`column` = VALUES (`column`);
answered Mar 26 at 11:00
SonOfWinterSonOfWinter
336 bronze badges
add a comment |
You can try this method to create or edit row
INSERT INTO `table` (`columns`) VALUES
(...)
ON DUPLICATE KEY UPDATE
`column` = VALUES (`column`);
answered Mar 26 at 11:00
SonOfWinterSonOfWinter
336 bronze badges
You can try this method to create or edit row
INSERT INTO `table` (`columns`) VALUES
(...)
ON DUPLICATE KEY UPDATE
`column` = VALUES (`column`);
answered Mar 26 at 11:00
SonOfWinterSonOfWinter
336 bronze badges
answered Mar 26 at 11:00
SonOfWinterSonOfWinter
336 bronze badges
answered Mar 26 at 11:00
SonOfWinterSonOfWinter
336 bronze badges
answered Mar 26 at 11:00
SonOfWinterSonOfWinter
336 bronze badges
336 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
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%2f55355349%2finsert-into-or-update%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
