CODEWITHSUNDEEP
mysqlsubquery
viraptor
viraptor

Reputation: 34145

Using subquery as value in mysql

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?

Upvotes: 0

Views: 293

Answers (2)

Ike Walker
Ike Walker

Reputation: 65537

Something like this should work for you:

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

Upvotes: 1

nickmoriarty
nickmoriarty

Reputation: 1263

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

Upvotes: 1

Related Questions