INSERT INTO FROM MySQL

How to insert into one table the values from another, including blanks or changing info on the way through:

INSERT IGNORE INTO table (field1,field2) SELECT concat('Added text ',fieldname) as field1,'blank' as field2 FROM oldtable WHERE statement = 1

Done!

TheGerbil
Monday 27th June 2011
Hey, this looks like a great tip!