Look up some help on the CREATE TABLE statement. My source says a bit about it: CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [select_statement] I am thinking that maybe you can do something like this: CREATE TABLE A_COPY SELECT * FROM A; possibly putting (create_definition,...) identical to table A's in between the two lines.
What I want to be able to do is move data from one database table to another, and then to export to a different server. I supppose I could export to Excel or MS_Access, but I'm trying to do the operation all within MySQL.
Is if I can "JOIN" the two tables, do you know the syntax that would accomplish what I'm trying to do below?
UPDATE A SET A.field2=B.field2 WHERE A.field1=B.field1
This seems like such a common need but if you could help me with a JOIN statement, possibly then I could export the data and load into a new table.
TIA,
Andrew Lietzow The ACL Group, Inc.