update table with replace string1 string2

0 votes

1 answer

32 views

                          I need replace string1 to string2 in column big tabe.
My table weight 1.7GB. For update I will be use:
UPDATE table SET column = REPLACE( column, 'search', 'replace' ) ; 

So, I have several questions:

1. Will table lock during procedure? Should I hide public part my site or not?  
2. How long time this procedure can executing?
3. How better run this? Maybe 'screen'? if my ssh connection will closed. 

Mysql 5.5.53

Asked by Pavel Gromov

Jun 15, 2017, 09:51 PM
Last activity: Jun 29, 2017, 05:12 AM

update table with replace string1 string2

Related Questions