Copying tables

[fallenangel1983]

Hey all,

 

Using php and mysql is there a way to copy a full row of a table into another table which is identical to the first one?

 

e.g. could this table:

 

    Table1                                          Table2

 

ITEM    PRICE                            ITEM      PRICE

 

Coffe    1.50  -------------->    empty    empty

 

Donut    2.00                              empty    empty

 

 

is this possible?

[sKunKbad]

Do you mean all in one query?

[fallenangel1983]

if there is a way yes

[sKunKbad]

There probably is, but you should post in the MySQL forum.