using subquery within an INSERT statement (with multiple rows)

can i insert multiple rows in one statement?

[techtheatre]

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

[whoisgregg]

Try this syntax instead:

INSERT INTO PagePlugins (PageName, PluginCode, PluginLabel)
SELECT DISTINCT PageName, 'plug_weather' AS PluginCode, 'Local Weather' AS PluginLabel 
FROM PageData

[techtheatre]

Awesome. I had way over-simplified the query in my post, but after tweaking my real query with this new format it works perfectly. Thanks!

[whoisgregg]

Glad I could help. :)