Bulk change in MYSQL

Question

Navigation

#1 by (0 votes)
#2 by (0 votes)

0

Hi everyone, all right?

I have a database in mysql and I need to make a bulk change, how?

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

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

Thank you!

mysql query

asked by anonymous 31.05.2017 / 20:52

2 answers

0

My suggestion update without where

UPDATE ptv_osrs_properties 
SET show_address = '1'

31.05.2017 / 20:56

score 0 · Accepted Answer

0

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

update ptv_osrs_properties set show_address = '1';

31.05.2017 / 20:56