TEENFRONT Posted November 8, 2006 Share Posted November 8, 2006 Hi everyone,I have a DB with 4 columns , name | email | type | active - i have imported a list of name and email so this are full.What would the php/mysql to update the other to colums with simply 1 entry. i need typre and active to be set to "utf8" and "yes" respectivly, but for all entries of name and email. Any help would be appreciated. Link to comment https://forums.phpfreaks.com/topic/26634-mysql-code-for-multi-insert/ Share on other sites More sharing options...
bqallover Posted November 8, 2006 Share Posted November 8, 2006 Your last sentence was a bit confusing, but if you mean set all rows to have the values you indicate, then connect to your database (if you don't know how, there are tons of tutorials) and run this query:UPDATE table_name SET type='utf8', active='yes' Link to comment https://forums.phpfreaks.com/topic/26634-mysql-code-for-multi-insert/#findComment-121845 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.