Friday, April 30, 2010

db porting task or db table migration

i was want to migrate the table and i have used this query which helpful


INSERT INTO tg_development.content_masters
(
content_text,
title,parent_id
)
(SELECT `fulltext`,title,CASE WHEN jos_content.sectionid=5 THEN 2 ELSE 3 END FROM tegeek_jo151.jos_content)

which have transfered the all data to other database..

No comments:

Post a Comment