Hey all
Jeg er ved at gå ud af mit goe skind over dette! Jeg laver en update på det
ene felt, men begge bliver updated. Se her:
+----------+----------------+----------------+
| username | created | last_login |
+----------+----------------+----------------+
| emax | 20030601142237 | 20030613164207 |
+----------+----------------+----------------+
1 row in set (0.00 sec)
mysql> UPDATE members SET last_login = now() WHERE member_id = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select username, created, last_login from members where member_id =
1;
+----------+----------------+----------------+
| username | created | last_login |
+----------+----------------+----------------+
| emax | 20030613164320 | 20030613164320 |
+----------+----------------+----------------+
1 row in set (0.00 sec)
WHAT THE FU**?
Prøver så at vende den om... kun update created
mysql> UPDATE members SET created = now() WHERE member_id = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select username, created, last_login from members where member_id =
1;
+----------+----------------+----------------+
| username | created | last_login |
+----------+----------------+----------------+
| emax | 20030613164349 | 20030613164320 |
+----------+----------------+----------------+
1 row in set (0.00 sec)
Ingen problemer her...
mysql> UPDATE members SET last_login = now() WHERE member_id = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select username, created, last_login from members where member_id =
1;
+----------+----------------+----------------+
| username | created | last_login |
+----------+----------------+----------------+
| emax | 20030613164400 | 20030613164400 |
+----------+----------------+----------------+
1 row in set (0.00 sec)
Same shit igen... eneste forklaring jeg kan komme til er at der er _ i
last_login og mysql bøvser over dette?
--
Take Care
Kim Emax - Freelance programmør
http://www.emax.dk -
http://www.ayianapa.dk
Køb din vin online på
http://www.gmvin.dk,
Danmarks måske mest avancerede VinWebShop