-
Syntax error....
hi.....
i have the query like this....
update ttt t
set (t.name,t.refid) = (select (tr.name,tr.ref_id) from tree tr where tr.id=t.id);
Is this possible in mySQL? If possible means . .wat is the syntax error in this query.
Thanks
S.Ashokkumar
-
syntax errors........
Hi Mr Ahhok
this is not possible here!
u r comparing two values with one = operator
this is wrong way
which version of mysql r u using?
send ur problem in detail
thanks and regards
manoj
Last edited by manoj_jnics1; 10-23-2006 at 09:44 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|