mySQL更新表将字符串添加到列

I have a table in mySQL and want to update a specific column holding a directory. The directory structure should be extended and the corresponding columns should be updated with a subdirectory. There are many rows to update so I look for a convenient script to do.I have a table in mySQL and want to update a sp