>You did not show us your actual insert statement, but
>You can not insert into a table listed anywhere in the select.
sorry,man. i should have been given you the whole thing:
here it comes:
db one with table person
(firstname,name,email,phone,fax,hashval,flag,etc...) and table hashvalue
(
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
>Does the PHP user have insert authority?
grant insert,alter,select on theTable to phpuser;
you mean this? php user is the user with whom the php file connects
to the db right?
i executed every statement from the shell as that user,too!
best regards
udo
--
MySQL General Mailing List
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 wi
