MySQL - Copying data from one table to another

Question

I'm trying to copy the data from one row and create a new one with some of the values.

I think I have it basically working BUT I want to set value of meta_key to additional_articles_0_article_url, and not copy the value "articles"

And after that occurs, create new row, with using the same post_id?

Any ideas?

INSERT INTO tpl_postmeta (post_id, meta_key, meta_value)
SELECT m.post_id, m.meta_key, m.meta_value
FROM tpl_postmeta m
WHERE m.meta_key = "articles" AND m.meta_value LIKE "%.com%";

INSERT INTO tpl_postmeta(post_id, meta_key, meta_value) 
VALUES ('same post_id as above','_additional_articles_0_article_title', 'New Article')

Gordon Linoff · Accepted Answer · 2015-05-06 21:08:46Z

2

I think you just want this:

INSERT INTO tpl_postmeta (post_id, meta_key, meta_value)
    SELECT m.post_id, 'additional_articles_0_article_url', m.meta_value
    FROM tpl_postmeta m
    WHERE m.meta_key = "articles" AND m.meta_value LIKE "%.com%";

answered May 6, 2015 at 21:08

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jonast92 Over a year ago

Just about to hit enter :)

ok1ha Over a year ago

Thanks, I just added one additional question

Collectives™ on Stack Overflow

MySQL - Copying data from one table to another

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related