View Single Post
Old 04-15-2007, 02:30 PM  
GrouchyAdmin
Now choke yourself!
 
GrouchyAdmin's Avatar
 
Industry Role:
Join Date: Apr 2006
Posts: 12,085
Quote:
Originally Posted by sarettah View Post
insert into newdatabasename.tablename(fieldlist) select fieldlist from olddatabasename.tablename

Where fieldlist is the lsit of fields you are pulling from one database/table into the other database/table
If he's using different databases, the chances are high that he does not have them on the same system... or just loves to use multiple databases.
__________________
GrouchyAdmin is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote