How To Copy And Get The Id.

i have 3 table.

table 1
table 2
table 3

table 1 is a cart
table 2 is customer details
table 3 is customer item buy item details

table 1 is let the customer buy their thing in here.
after he check out all the table 1 data will go to table 2 and table 3.

now my problem is how did it doing.
i using The SELECT INTO Statement but got error

Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a From cart where cus_id='2'' at line 1
/admin/order_details.asp, line 5 Code: