Re: Is It Possible To Change the Value of A Particular Field Manually?
Carlonie, Use the UPDATE. I assume you mean by database here you mean the database table named members... if so, try the following query. UPDATE members SET user_name = 'john_doe' WHERE user_name = 'John Doe'; -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Quality Web Hosting http://www.justlightening.net MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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. __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is It Possible To Change the Value of A Particular Field Manually?
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. __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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/[EMAIL PROTECTED]
Re: Is It Possible To Change the Value of A Particular Field Manually?
you can optionally use MySQL Front to view and edit data in GUI mode get it free of cost athttp://www.mysqlfront.de/ Enjoy Nitin - Original Message - From: Michael Stassen [EMAIL PROTECTED] To: Caroline Jen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]