Try searching for a row that has a login_date of '-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
> Date: Thu, Sep 8, 2011 at 4:28 AM
> Su
Any update from anybody ?
-- Forwarded message --
From: umapathi b
Date: Thu, Sep 8, 2011 at 4:28 AM
Subject: Re: strange mysql update ..
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Here is the o/p after the update ..
user_id: 16078845
drivers_license
Nice Rik!
On Thu, Sep 8, 2011 at 3:19 PM, Rik Wasmus wrote:
> > 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 us
> 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
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:
completion_date: 2011-06-19 11:37:16
print_date: NULL
passwor
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 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
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-