Hi All
I've xml contents in a column of one table. Inside that xml content, I've
sometime an hardcoded link which I needs to change automatically (lets
say:
from host.domain.com/dev to host2.domain.com)
I'm searching how to build the sql statement to do it but I don't
understand
how to do
Thank you all for your reply, it works perfectly.
Gael
Victor Pendleton [EMAIL PROTECTED] wrote on 21/05/2004 16.55.23:
One option:
UPDATE table_name
SET col_name = REPLACE(col_name, 'host.domain.com', 'host2.domain.com')
WHERE some_restriction
-Original Message-
From: [EMAIL
Hi All,
I performed the backup (mysqldump -u username -p db backup.sql) of a
database on a Win32 (4.0.15-max-debug) server in order to restore it on
Linux server (4.0.15-9)
When I try to restore it on the linux machine (with mysql -u username -p
db backup.sql), there is an error saying:
It works like a charme with the -Q option
Thank you
Gael
Victoria Reznichenko [EMAIL PROTECTED] wrote on 23/04/2004
11.26.01:
[EMAIL PROTECTED] wrote:
I performed the backup (mysqldump -u username -p db backup.sql) of a
database on a Win32 (4.0.15-max-debug) server in order to