Hello everyone,
Is there a function that first tests if a record exists, and if so updates
it, or if it does not exists, it creates that new record?
I know I can do that by checking the list of records, then update the table.
But that requires 2 queries. If I could get that done by one, that wou
Thanks, I'll do that.
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 4:52 PM
To: LeTortorec, Jean-Louis
Cc: '[EMAIL PROTECTED]'
Subject: Re: Problem with sum()
Because neither 0.7 nor 0.1 have an exact binary
Hello every one,
I have a simple table, with a "float" field called quantity.
In this table, there are 2 records: 1 with quantity=0.7, and 1 with
quantity=0.1.
When I do a "select sum(quantity) from mytable", I got 0.798956919
instead of 0.8.
Does any body know why?
Thanks.
Jean-Louis
Hello every one:
I have a problem modifying the structure of a table:
ALTER TABLE t_logs CHANGE log_id log_id INT(11) NOT NULL
AUTO_INCREMENT;
ERROR 1: Can't create/write to file './intranet/#sql-484_285.frm'
(Errcode: 13)
I made sure that the rights on the MYI, MYD and frm file
I have a table with the following fields:
id=autoincrement, int (11)
ts_h=decimal
ts_pid=int (11)
ts_day=text
There is a unique record where ts_pid=60 and ts_day="2002032800"
(ts_h=0).
If I do [update t_timesheet set ts_h=0 where ts_pid=60 and
ts_day="2002032800" ],
