I have a strange problem: we have two OpenBSD 4.3 AMD64 servers. We
upgraded one of them from 4.1 to 5.0 with no problem. But we are unable
to upgrade the second one!
All the compilation and installation is OK (version 5.0.67). But when we
try to run the server it stops and the following error
Since we upgraded from MySQL 4.0 to 5.0 (under OpenBSD 4.1 amd64) the
following command:
select count(*) as total from products_description pd, products p left
join manufacturers m on p.manufacturers_id = m.manufacturers_id,
products_to_categories p2c left join specials s on p.products_id =
s
Fred van Engen wrote:
>
> Hi,
>
> On Fri, Mar 23, 2001 at 07:46:48PM +0100, Federico Giannici wrote:
> > We have a table where we register the data of all the modem connections
> > of the users of a small ISP.
> >
> > The table contains 2 million rec
We have a table where we register the data of all the modem connections
of the users of a small ISP.
The table contains 2 million records and has the following structure:
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | E
In a SELECT I have to convert a string into a number.
I used to use something like 'string'+0, where 'string' is a string
rapresentation of an integer.
Now I noticed that in many cases it returns a rounded floating point!!!
For example:
mysql> select '11'+0;
+-+
| '11'+0
