At the moment, according to the doc: http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html# Missing_Sub-selects
MySQL only support the insert select and Replace Select. I am not sure if that answer your question as I am not a big guru on it either, but it is a place to start and if it is possible, I am sure someone else will give you the real full answer. Daniel > > Hi all, > > I am new in mysql and want to analyse between some popular > databases. I have > a SQL: > > update ta set f1 = ( select af1 from tb where ta.id = tb.id ); > > It can be done in postgreSQL and Oracle. How can I do the same tasks in > MySQL without using Perl? Is it possible to do this tasks just > enter the SQL > statement? > > Kenenth. > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
