MySQL Forums
Forum List  »  Newbie

Overcoming MySQL 3x INSERT...SELECT Limitation
Posted by: Xeon Masters
Date: August 31, 2004 01:13PM


Are there any methods to overcome INSERT...SELECT limitiation of not referencing the same table in the FROM clause? (other than upgrading MySQL to a newer version)

I've tried this statement but fails:

INSERT INTO foo SELECT NULL, some_col_name
FROM foo AS fooAlias
WHERE some_constraint

I've considered of using views, but alas, it's implemented on v5.

Plz Help

Options: ReplyQuote

Written By
Overcoming MySQL 3x INSERT...SELECT Limitation
August 31, 2004 01:13PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.