hi i want to be able to copy all the fields and values in a table in one databse to a table in another database. is there any way this can be done?

The lazy way is by just using a tool like PHPMyAdmin.

Donny

yeah i know it can be done with phpadmin but i want to do it with sql. any statements i can use for this?

IF the databases are on the same machine,

create table newdb.newtable select * from olddb.oldtable;

Or, if the new tables have already been created,

insert into newdb.newtable select * from olddb.oldtable;