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.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
