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
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 tec
02 11:04
Para: [EMAIL PROTECTED]
Asunto: re: RE: UPDATE
Cesar,
Thursday, December 05, 2002, 2:50:30 AM, you wrote:
CA> The problem shows up when receiving the response of the query which
CA> tells me that the query was OK but rows affected.
How many row were affected? 0? Was the passw
Cesar,
Thursday, December 05, 2002, 2:50:30 AM, you wrote:
CA> The problem shows up when receiving the response of the query which
CA> tells me that the query was OK but rows affected.
How many row were affected? 0? Was the password changed?
--
For technical support contracts, goto https://
Rodrigo,
Tuesday, November 12, 2002, 10:44:38 PM, you wrote:
>> I want to change a tablename in my database. How do i do that? I want to
RSM> do
>> it from a webpage so i need to use php.
Take a look at ALTER TABLE statement:
http://www.mysql.com/doc/en/ALTER_TABLE.html
or RENAME TABLE stat
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> RSV
Well, Jeff you are right! I've just taken the
wrong line from .mysql_history file. It was one
of my thousands of tries to make the ORDER BY work
with UPDATE. What I really try to do is ORDER BY
the 'received' column, which is a timestamp.
The point is if I have plenty of alarm messages
which are n
