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: [email protected]
- Umapathi
On Thu, Sep 8, 2011 at 4:23 AM, Ananda Kumar <[email protected]> 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 <[email protected]> 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: [email protected]
>>
>> 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
>> [email protected]
>>
>
>
