The replace tag has no wiki summary.
4
votes
2answers
2k views
Update many rows in a table with a single statement?
What is the easiest way to update many rows in a table? I have a csv file that looks like this:
|primary_key |value|
| 1 | xyz|
| 2 | abc|
| 3 | def|
...
Rows with ...
0
votes
1answer
346 views
Query to find and replace text in all tables and fields of a mysql db
I need to run a query to find and replace some text in all tables of a mysql database.
I found this query, but it only looks for the text in the tbl_name table and just in the column field.
update ...
