Re: Re: Re: UPDATE not working ...
On Friday 10 January 2003 21:43, you wrote:
mysql UPDATE t SET d=UNIX_TIMESTAMP(DATE_ADD(c, interval (b) day)) / 1;
ERROR 1105: Unknown error
Thanks for bug report!
This is a patch from Sinisa Milivojevic:
= sql/item.cc 1.24 vs edited =
*** /tmp/item.cc-1.24-3175 Tue Dec 3 13:08:21 2002
--- edited/sql/item.cc Fri Jan 10 21:38:55 2003
***
*** 505,511
{
double nr=val();
if (null_value)
! return set_field_to_null(field);
field-set_notnull();
field-store(nr);
}
--- 505,511
{
double nr=val();
if (null_value)
! return set_field_to_null_with_conversions(field, no_conversions);
field-set_notnull();
field-store(nr);
}
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ www.mysql.com
-
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
re: RE: RE: UPDATE
On Thursday 12 December 2002 03:32, Cesar Aracena wrote: Exaclty, 0 rows affected, but no password changed... why's that? Thanks, If 0 rows were affected it's normal that password was not changed :) If you do a SELECT with the same condition, does MySQL find the any matched rows? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Re: Re: RE: update syntax
Hello Terry, Thursday, June 20, 2002, 5:14:40 PM, you wrote: DT Egor, DT I hope I understand you work for MySQL in some fashion, is there any plan to DT allow sub-selects in future releases ? Yes, multi-table updates and sub-selects is on development and they will come in version 4.1 DT RSVP, DT Terry -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
