Using subquery as value in mysql

Question

I'm looking for a way to quickly process some table in mysql 5.0.X. I'd like to insert a row into t1 for each row in t2. Essentially, I'd like something like this to map over every row:

REPLACE INTO t1 VALUES (CONCAT('blah/', (select username from t2)), 'value')

Is that possible without procedures?

Ike Walker · Accepted Answer · 2011-02-22 22:32:43Z

1

Something like this should work for you:

REPLACE INTO t1
SELECT CONCAT('blah/',username), 'value'
FROM t2

answered Feb 22, 2011 at 22:32

Ike Walker

65.8k14 gold badges115 silver badges112 bronze badges

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

Comments

nickmoriarty · Accepted Answer · 2011-02-22 21:43:51Z

1

Sounds like you are looking for the INSERT SELECT statement unless I am misunderstanding. Check this link for details.

answered Feb 22, 2011 at 21:43

nickmoriarty

1,26319 silver badges23 bronze badges

Collectives™ on Stack Overflow

Using subquery as value in mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related