petro writes:
> Hello!
> Need some help.....
> I have two tables
> t1 with fields id and site
> t2 with fields id, from, to, koef
> I want to update t2 set koef=2 if the from field in t2 table exist in
> t1.url....
> such update return error.
> update t2, t1 set t2.koef=0 where t2.from=t1.site
>
> Thank yoo very much.
>
Hi!
This kind of update is in the works on the 4.0 branch.
With 3.23, if you can program in C++, you may take a look at
updel_x.cc example in MySQL++ source distro.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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