Msg#: 4047468 posted 9:51 am on Dec 22, 2009 (gmt 0)
So...it may simply not be possible, but I want to have an insert statement (or whatever) to insert new rows into my database with some info coming from another table. the problem is that this requires the insertion of multiple rows. I know I can do it one row at a time, but that is going to be VERY tedious (several thousand rows).
INSERT INTO PagePlugins (PageName, PluginCode, PluginLabel) VALUES ( (SELECT DISTINCT PageName FROM PageData),'plug_weather','Local Weather' )
I get the following error: MySQl: #1242 - Subquery returns more than 1 row