Heikki,
HT> check by other queries whether it is the table which contains a
HT> duplicate row, or if the SELECT gives a wrong answer.
HT> Check what
HT> SELECT * FROM ... WHERE symbole='1rPFTE';
HT> returns.
Really strange :
mysql> select * from livequote_last_PAR where symbole='1rPFTE' o
Heikki,
Another exemple :
mysql> select * from livequote_last_PAR where symbole='1rPFTE' order by id desc;
+-+---+-+--++
| symbole | id| date| last | volume |
+-+---+-+--++
|
Heikki,
I did the downgrade to Mysql-3.23.36. I don't have this problem with
3.23.36 !
Alex.
HT> check by other queries whether it is the table which contains a
HT> duplicate row, or if the SELECT gives a wrong answer.
HT> Check what
HT> SELECT * FROM ... WHERE symbole='1rPFTE';
HT> r
Alex,
check by other queries whether it is the table which contains a
duplicate row, or if the SELECT gives a wrong answer.
Check what
SELECT * FROM ... WHERE symbole='1rPFTE';
returns.
Regards,
Heikki
At 12:04 PM 4/25/01 +0200, you wrote:
>Bonjour,
>
> Mysql-3.23.37 on Solaris 2.8.
>
>
Bonjour,
Mysql-3.23.37 on Solaris 2.8.
I created this table :
CREATE TABLE livequote_last_PAR (
symbole char(20) NOT NULL default '',
id int(10) unsigned NOT NULL default '0',
date datetime NOT NULL default '-00-00 00:00:00',
last double(17,5) NOT NULL default '0.0',
volum
