List:General Discussion« Previous MessageNext Message »
From:Nitin Date:December 18 2003 6:50am
Subject:Re: Is It Possible To Change the Value of A Particular Field Manually?
View as plain text  
you can optionally use MySQL Front to view and edit data in GUI mode

get it free of cost at    http://www.mysqlfront.de/

Enjoy
Nitin

----- Original Message ----- 
From: "Michael Stassen" <Michael.Stassen@stripped>
To: "Caroline Jen" <jiapei_jen@stripped>
Cc: <mysql@stripped>
Sent: Thursday, December 18, 2003 11:28 AM
Subject: Re: Is It Possible To Change the Value of A Particular Field
Manually?


>
> Caroline Jen wrote:
> > Hi, I am not a database person.  I have a database
> > called "members".  One of the fields in this database
> > is "user_name".   There are a number of records in
> > this database.  Under the field user_name, I would
> > like to make some changes manually; for example, I
> > want to change
> >
> > John Doe
> >
> > to
> >
> > john_doe
> >
> > Is it possible to do it?  How do I do it?  Thank you
> > very much in advance.
>
> Yes.  You can specify the records you want with a WHERE clause.  First
> try a SELECT to test your WHERE clause to make sure you get just the
> record(s) you want:
>
> SELECT * FROM members WHERE user_name = 'John Doe';
>
> As long as that looks right, then use UPDATE to modify the record(s):
>
> UPDATE members SET user_name='john_doe' WHERE user_name = 'John Doe';
>
> See <http://www.mysql.com/doc/en/UPDATE.html> in the manual for more.
>
> Michael
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>


Thread
Is It Possible To Change the Value of A Particular Field Manually?Caroline Jen18 Dec
  • Re: Is It Possible To Change the Value of A Particular Field Manually?Michael Stassen18 Dec
  • Re: Is It Possible To Change the Value of A Particular Field Manually?Nitin18 Dec
  • Re: Is It Possible To Change the Value of A Particular Field Manually?Mike Blezien20 Dec