List:General Discussion« Previous MessageNext Message »
From:BAUMEISTER Alexandre Date:April 25 2001 12:07pm
Subject:Re[2]: Primary key not unique on Innodb tables.
View as plain text  
Heikki,

  Another exemple :

mysql> select * from livequote_last_PAR where symbole='1rPFTE' order by id desc;
+---------+-------+---------------------+----------+--------+
| symbole | id    | date                | last     | volume |
+---------+-------+---------------------+----------+--------+
| 1rPFTE  | 33561 | 2001-04-25 14:04:04 | 78.60000 |    150 |
| 1rPFTE  | 33560 | 2001-04-25 14:03:13 | 78.50000 |     30 |
| 1rPFTE  | 33559 | 2001-04-25 14:02:20 | 78.45000 |     27 |
| 1rPFTE  | 33558 | 2001-04-25 14:02:11 | 78.50000 |   1000 |
| 1rPFTE  | 33557 | 2001-04-25 14:02:11 | 78.50000 |     38 |
| 1rPFTE  | 33556 | 2001-04-25 14:02:03 | 78.50000 |     27 |
| 1rPFTE  | 33555 | 2001-04-25 14:01:39 | 78.50000 |     28 |
| 1rPFTE  | 33554 | 2001-04-25 14:01:23 | 78.50000 |    246 |
| 1rPFTE  | 33553 | 2001-04-25 14:01:21 | 78.50000 |    488 |
| 1rPFTE  | 33552 | 2001-04-25 14:01:21 | 78.55000 |   1512 |
+---------+-------+---------------------+----------+--------+
10 rows in set (0.00 sec)

UPDATE livequote_last_PAR SET date=concat(CURDATE(), '
14:04:51'),last=78.500000,volume=32,id=33562 WHERE symbole='1rPFTE' AND id=33552

mysql> select * from livequote_last_PAR where symbole='1rPFTE' order by id desc;
+---------+-------+---------------------+----------+--------+
| symbole | id    | date                | last     | volume |
+---------+-------+---------------------+----------+--------+
| 1rPFTE  | 33562 | 2001-04-25 14:04:51 | 78.50000 |     32 |
| 1rPFTE  | 33561 | 2001-04-25 14:04:04 | 78.60000 |    150 |
| 1rPFTE  | 33560 | 2001-04-25 14:03:13 | 78.50000 |     30 |
| 1rPFTE  | 33559 | 2001-04-25 14:02:20 | 78.45000 |     27 |
| 1rPFTE  | 33558 | 2001-04-25 14:02:11 | 78.50000 |   1000 |
| 1rPFTE  | 33557 | 2001-04-25 14:02:11 | 78.50000 |     38 |
| 1rPFTE  | 33556 | 2001-04-25 14:02:03 | 78.50000 |     27 |
| 1rPFTE  | 33555 | 2001-04-25 14:01:39 | 78.50000 |     28 |
| 1rPFTE  | 33554 | 2001-04-25 14:01:23 | 78.50000 |    246 |
| 1rPFTE  | 33553 | 2001-04-25 14:01:21 | 78.50000 |    488 |
+---------+-------+---------------------+----------+--------+
10 rows in set (0.01 sec)

UPDATE livequote_last_PAR SET date=concat(CURDATE(), '
14:04:57'),last=78.450000,volume=42,id=33563 WHERE symbole='1rPFTE' AND id=33553
UPDATE livequote_last_PAR SET date=concat(CURDATE(), '
14:04:57'),last=78.450000,volume=91,id=33564 WHERE symbole='1rPFTE' AND id=33554

mysql> select * from livequote_last_PAR where symbole='1rPFTE' order by id desc;
+---------+-------+---------------------+----------+--------+
| symbole | id    | date                | last     | volume |
+---------+-------+---------------------+----------+--------+
| 1rPFTE  | 33564 | 2001-04-25 14:04:57 | 78.45000 |     91 |
| 1rPFTE  | 33564 | 2001-04-25 14:04:57 | 78.45000 |     91 |
| 1rPFTE  | 33563 | 2001-04-25 14:04:57 | 78.45000 |     42 |
| 1rPFTE  | 33563 | 2001-04-25 14:04:57 | 78.45000 |     42 |
| 1rPFTE  | 33562 | 2001-04-25 14:04:51 | 78.50000 |     32 |
| 1rPFTE  | 33561 | 2001-04-25 14:04:04 | 78.60000 |    150 |
| 1rPFTE  | 33560 | 2001-04-25 14:03:13 | 78.50000 |     30 |
| 1rPFTE  | 33559 | 2001-04-25 14:02:20 | 78.45000 |     27 |
| 1rPFTE  | 33558 | 2001-04-25 14:02:11 | 78.50000 |   1000 |
| 1rPFTE  | 33557 | 2001-04-25 14:02:11 | 78.50000 |     38 |
| 1rPFTE  | 33556 | 2001-04-25 14:02:03 | 78.50000 |     27 |
| 1rPFTE  | 33555 | 2001-04-25 14:01:39 | 78.50000 |     28 |
+---------+-------+---------------------+----------+--------+
12 rows in set (0.00 sec)

  Alex.


Thread
Innobase name changes to InnoDB in 3.23.37, have to changemy.cnfHeikki Tuuri13 Apr
  • Primary key not unique on Innodb tables.BAUMEISTER Alexandre25 Apr
Re: Primary key not unique on Innodb tables.Heikki Tuuri25 Apr
  • Re[2]: Primary key not unique on Innodb tables.BAUMEISTER Alexandre25 Apr
  • Re[2]: Primary key not unique on Innodb tables.BAUMEISTER Alexandre25 Apr
  • Re[2]: Primary key not unique on Innodb tables.BAUMEISTER Alexandre25 Apr