MySQL Forums
Forum List  »  Quality Assurance

SQL query does not find record (randomly) - SOLVED
Posted by: Tomas Holenda
Date: November 21, 2012 11:14AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
SQL query does not find record (randomly) - SOLVED
2733
November 21, 2012 11:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.