Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature may not be available in some browsers.
UPDATE `bon` SET val=(SELECT `bon`, `uhrzeit` * FROM `testges` WHERE `bon`!=0,) ;
WHERE uhrzeit.val < `uhrzeit` INSERT INTO `bon`
so kanns auch nicht gehen.PHP:UPDATE `bon` SET val=(SELECT `bon`, `uhrzeit` * FROM `testges` WHERE `bon`!=0,) ; WHERE uhrzeit.val < `uhrzeit` INSERT INTO `bon`
mysql> select * from tabelle;
+----+------+---------+---------------------+------+
| id | ean | smr | uhrzeit | bon |
+----+------+---------+---------------------+------+
| 1 | 123 | gelesen | 2015-05-28 14:00:00 | 0 |
| 2 | 123 | gelesen | 2015-05-28 14:00:01 | 0 |
| 3 | 123 | gelesen | 2015-05-28 14:00:02 | 0 |
| 4 | 123 | bon | 2015-05-28 14:03:00 | 99 |
| 5 | 124 | gelesen | 2015-05-28 14:10:00 | 0 |
| 6 | 124 | gelesen | 2015-05-28 14:10:01 | 0 |
| 7 | 124 | gelesen | 2015-05-28 14:10:02 | 0 |
| 8 | 124 | bon | 2015-05-28 14:13:00 | 4711 |
+----+------+---------+---------------------+------+
8 rows in set (0,00 sec)
mysql> UPDATE tabelle b SET bon=
-> ( SELECT bon FROM ( SELECT * FROM tabelle WHERE bon <> 0 ) n WHERE n.uhrzeit > b.uhrzeit LIMIT 1)
-> WHERE b.bon=0
-> ORDER BY b.uhrzeit;
Query OK, 6 rows affected, 2 warnings (0,02 sec)
Rows matched: 6 Changed: 6 Warnings: 2
mysql> select * from tabelle;
+----+------+---------+---------------------+------+
| id | ean | smr | uhrzeit | bon |
+----+------+---------+---------------------+------+
| 1 | 123 | gelesen | 2015-05-28 14:00:00 | 99 |
| 2 | 123 | gelesen | 2015-05-28 14:00:01 | 99 |
| 3 | 123 | gelesen | 2015-05-28 14:00:02 | 99 |
| 4 | 123 | bon | 2015-05-28 14:03:00 | 99 |
| 5 | 124 | gelesen | 2015-05-28 14:10:00 | 4711 |
| 6 | 124 | gelesen | 2015-05-28 14:10:01 | 4711 |
| 7 | 124 | gelesen | 2015-05-28 14:10:02 | 4711 |
| 8 | 124 | bon | 2015-05-28 14:13:00 | 4711 |
+----+------+---------+---------------------+------+
8 rows in set (0,00 sec)