emorr1981 Posted March 10, 2007 Share Posted March 10, 2007 Hello, I have a mysql table Name , phone, email, address How do I just enter the name and update the address (phone and email stays the same as before) Thanks you Link to comment https://forums.phpfreaks.com/topic/42093-how-to-update-partial-table/ Share on other sites More sharing options...
OOP Posted March 10, 2007 Share Posted March 10, 2007 Hi there, you can specify the field name that you want to update in your update statement. Something like this: UPDATE `table_name` SET name = 'Your new name value', address = 'Your new address value' WHERE user_id = 'user id' Link to comment https://forums.phpfreaks.com/topic/42093-how-to-update-partial-table/#findComment-204167 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.