Hi.
With MySQL, there is not (yet) a way to do this with a single
command. A poor SQL work-around is possible, but a bit bloated.
On the other hand, ta.f1 is a redundand field (regarding tb.af1) and
therefore you normally would seldom need a command such as the one
below.
One (quite probably
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
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