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
>>>
>>
>>
