List:General Discussion« Previous MessageNext Message »
From:Derek Downey Date:September 9 2011 1:00pm
Subject:Re: strange mysql update ..
View as plain text  
Try searching for a row that has a login_date of '0000-00-00 00:00:00'

- Derek

On Sep 9, 2011, at 8:52 AM, umapathi b wrote:

> Any update from anybody ?
> 
> 
> ---------- Forwarded message ----------
> From: umapathi b <umapathi.b@stripped>
> Date: Thu, Sep 8, 2011 at 4:28 AM
> Subject: Re: strange mysql update ..
> To: Ananda Kumar <anandkl@stripped>
> Cc: mysql@stripped
> 
> 
> Here is the o/p after the update ..
> 
> 
>           user_id: 16078845
>   drivers_license: TEST1140DL
>        login_date: 2011-06-19 11:20:07
>         course_id: 1011
>      regulator_id: 10840
>         test_info: 11111111
>   completion_date: 2011-06-19 11:37:16
>        print_date: NULL
>          password: test1140dl
> certificate_number: NULL
>             login: test1140dl@stripped
> 
> 
> - Umapathi
> 
> 
> On Thu, Sep 8, 2011 at 4:23 AM, Ananda Kumar <anandkl@stripped> wrote:
> 
>> Can you lets us know what is the output of
>> 
>> select * from user_info where user_id=16078845;
>> 
>> 
>> On Thu, Sep 8, 2011 at 1:02 PM, umapathi b <umapathi.b@stripped> wrote:
>> 
>>> I wanted to change the login_date of one user . The original data of that
>>> user is like this ..
>>> 
>>> select * from user_info where user_id = 16078845 \G
>>> *************************** 1. row ***************************
>>>          user_id: 16078845
>>>  drivers_license: TEST1140DL
>>>       login_date: 2011-06-19 11:20:07
>>>        course_id: 1011
>>>     regulator_id: 10840
>>>        test_info: 11111111
>>>  completion_date: 2011-06-19 11:37:16
>>>       print_date: NULL
>>>         password: test1140dl
>>> certificate_number: NULL
>>>            login: test1140dl@stripped
>>> 
>>> I fired the update statement in a wrong way ..like this ..
>>> 
>>> update user_info set login_date='2011-08-05 04:15:05' and user_id
>>> =16078845
>>> limit 1 ;
>>> ( I forgot to use where . instead of where I used and )
>>> update user_info set login_date='2011-08-05 04:15:05' where user_id
>>> =16078845 limit 1 ; ( this is the query intended )
>>> 
>>> after the update ..I got this message ..
>>> mysql> update user_info set login_date='2011-08-05 04:15:05' and user_id
>>> =16078845 limit 1;
>>> Query OK, 1 row affected, 1 warning (0.02 sec)
>>> Rows matched: 1  Changed: 1  Warnings: 0
>>> 
>>> It shows that one record is affected and one row changed ..
>>> I did show warnings ..the output is like this ..
>>> 
>>> mysql> show warnings;
>>> 
>>> +---------+------+---------------------------------------------------------+
>>> | Level   | Code | Message
>>> |
>>> 
>>> +---------+------+---------------------------------------------------------+
>>> | Warning | 1292 | Truncated incorrect DOUBLE value: '2011-08-05 04:15:05'
>>> |
>>> 
>>> 
>>> +---------+------+---------------------------------------------------------+
>>> 
>>> But I could not get any record in the table with the updated login_date ..
>>> mysql> select * from user_info where login_date like '2011-08-05%' ;
>>> Empty set (0.67 sec)
>>> 
>>> So my question is what happened exactly ?
>>> Why no records updated ?
>>> 
>>> Help is highly appreciated in this regard ..
>>> 
>>> - Umapathi
>>> umapathi.b@stripped
>>> 
>> 
>> 

Thread
strange mysql update ..umapathi b8 Sep
  • Re: strange mysql update ..Ananda Kumar8 Sep
    • Re: strange mysql update ..umapathi b8 Sep
      • Fwd: strange mysql update ..umapathi b9 Sep
        • Re: strange mysql update ..Derek Downey9 Sep
  • Re: strange mysql update ..Rik Wasmus8 Sep
    • Re: strange mysql update ..Suresh Kuna9 Sep