How to I mass alter a MySQL database?

I have a database, and I want to alter all rows for a field in a specific table, but I don't know the sql command I should use.

eg, for table 'bnt_ships' I want to set all rows in the field 'score' to '0'. I'm not quite sure how to do it.

 

type in phpmyadmin sql query windows

update bnt_ships set score=0;

//will update all score to 0

update bnt_ships set score=0 where condition bla..bla ;

// will update only if condition meet.

 

Thanks. I was on the right lines, but the actual code required wan't in my reference books.

 

Slight variation of this.

For the table phpbb_adr_shops_items how do I update the table so that the column item_restrict_level has the same value as the column item_power?

 

try this:

UPDATE phpbb_adr_shops_items SET item_restrict_level=column_item_power

Code (markup):

 

Thanks, got it to work