how to replace value in whole database.

[zohab]

hi all,

 

if i want to update table with new value i will do as

update table set id='4' where id='3'

this will replace id='3' to id='4'

 

table

id name

1  name1

2  name2

3 name3

 

but if i want to replace it in whole database ,how will i do it.

 

table 1

id name

1  name1

2  name2

3 name3

 

table 2

id name

1  name1

2  name2

3 name3

 

table 3

id name

1  name1

2  name2

3 name3

 

any ideas?

 

[trq]

Why would you have three different tables storing what appears to be the same information?

 

You will need to use 3 seperate queries.

[zohab]

hi thorpe ,

 

I have 100 tables in my database and i want to replace 'xyz' to 'pqr'

 

I am not able to do it for every table.For this i have to write 100 queries.

 

i want to run one small query that will replace 'xyz' to 'pqr' in whole database (includes 100 tables)

 

[peddel]

hi thorpe ,

 

I have 100 tables in my database and i want to replace 'xyz' to 'pqr'

 

I am not able to do it for every table.For this i have to write 100 queries.

 

i want to run one query that will replace 'xyz' to 'pqr' in whole database (includes 100 tables)

 

 

First create a VIEW by using a UNION between all the 100 tables

Then maken 1 query on that VIEW

 

Usefull info :

http://dev.mysql.com/doc/refman/5.0/en/create-view.html

http://dev.mysql.com/doc/refman/5.0/en/union.html