View Full Version : copy records from table to table in MySQL?

07-29-2005, 08:40 AM
Hey there,

if i have two tables in one database with identical fields, can i copy records from one table into another ? can i do this by selecting records that meet a certain criteria and import just those?
i suppose i could export everything to a CVS then import that, but is there a more direct way?