You did not show us your actual insert statement, but .... You can not insert into a table listed anywhere in the select.
Udo Schubert wrote:
hi there!
i'm wondering about these sub-selects and the mysql-version peroblems they cause!
somewhere on mysql.com is said:
sub-selects need mysql version 4.1 and up!
BUT:
i have a statement
insert into foo select bar from bartable;
this thing works if i enter it on the mysql-shell. (also with some join and where parts added)
but if i query my mysql db with that statement from a php file i get DB::ERROR : unknown error !
nobody helped my at the php/pear list so i'm placing it here!
my mysql version is 11.15 dist 3.23.41
has anybody an idea,whether i have to upgrade my server,or the php module
the server works with?
best regards and thanks in advance
udo
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
