SQL query does not find record (randomly) - SOLVED
Hi,
I was surprised by what the server MySQL is doing. I run a query, the result is always different. My frontend is php and phpmyadmin.
My query:
update cidla set temperature=1 where owtest='28.4081DE030000'
Fist run:
1 row affected
Second run:
0 row afected
My table:
CREATE TABLE `cidla` (
`owid` varchar(20) COLLATE utf8_czech_ci NOT NULL,
`temperature` float(10,2) NOT NULL,
`updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`owid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
My data:
INSERT INTO `cidla` (`owid`, `temperature`, `updated`) VALUES
('3A.B06803000000', 0.00, '2012-11-21 15:11:14'),
('28.4081DE030000', 1.00, '2012-11-21 16:40:23'),
('28.B941DE030000', 7.94, '2012-11-21 15:23:24'),
('10.D2BCCD010800', 23.38, '2012-11-21 15:23:22');
My version:
localhost ~ # mysql -V
mysql Ver 14.14 Distrib 5.1.66, for pc-linux-gnu (i486) using readline 5.1
Please help me,
Thanks Tomas
Edited 1 time(s). Last edit at 11/22/2012 04:27PM by Tomas Holenda.