Mailinglist Archive: opensuse (4288 mails)

[Alexander Klayman <aklayman@xxxxxxxxxxxxxx>]

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.