How use table column as string in a multi-table update in MySQL?

Question

Two tables,

agent(agent_id, agent_real_name, .....)
blog(blog_id, blog_agent_id, blog_name, ...)

Now I want to set the blog_name as agent_real_name + "'s blog" I used following SQL sentence but failed,

update blog, agent set blog_name = agent_real_name '\'s blog' where agent_id = 31

PS: 31 is the id of a agent

What's wrong?

Thanks.

Joseadrian · Accepted Answer · 2011-03-06 02:34:09Z

2

UPDATE blog b INNER JOIN agent a
ON a.agent_id = b.blog_agent_id
SET b.blog_name = CONCAT(a.agent_real_name,'\'s blog') 
WHERE a.agent_id = 31

answered Mar 6, 2011 at 2:34

Joseadrian

4,4042 gold badges18 silver badges7 bronze badges

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

Comments

soasme · Accepted Answer · 2011-03-06 02:31:38Z

1

try to use: update blog, agent set blog_name = concat(agent_real_name, '\'s blog') where agent_id = 31

answered Mar 6, 2011 at 2:31

soasme

3921 gold badge5 silver badges11 bronze badges