Bulk change to MYSQL

Asked

Viewed 522 times

0

Hey, guys, all right?

I have a database in mysql and I need to make a massive change, it’s like?

I want to change all records from the "show_address" column of the ptv_osrs_properties table to "1".

I have about 300 records, I can do this in bulk at once?

Thank you!

2 answers

0

My suggestion update without Where

UPDATE ptv_osrs_properties 
SET show_address = '1'

0


I’m not sure I got it right, but if you want to update all the table records, just do an update:

update ptv_osrs_properties set show_address = '1';

Browser other questions tagged

You are not signed in. Login or sign up in order to post.