The replace tag has no wiki summary.
0
votes
1answer
350 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 ...
2
votes
2answers
855 views
Remove the last character from Variable String
I have a few variable data in the column "email".
For example:
roy2087@gmail.com123
sg123@yahoo.compori
How do I get rid of the characters after .com?
I used Replace(email,'.com%',gmail.com), ...
1
vote
1answer
87 views
Query to change all field in a given mysql table?
I have a table with a timestamp field called "time".
I have many records in this table and "time" has value like: 1343296642, 1343308689...
I need to run a query to subtract 2 years of time to those ...
1
vote
1answer
78 views
How to prepare a date and double for a mysql replace statement?
I have a MySql table with three columns:
CU VARCHAR(3)
DA DATETIME
VA DOUBLE
I need to execute several REPLACE into mytable (CU, DA, VA) values("ABC", mydate, myval) statements from Java. mydate is ...
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 ...
