Andrew -
insert
into Table1
(Username
,Password)
select
Username,
Password
from
OldTable
and
insert
into Table2
(First_Name
,Last_Name
,Country
,Birth_Date)
select
First_Name,
Last_Name,
Country,
Birth_Date
from
OldTable
I think you want Table1 and Table2 to have a Primary Key (each).
-brian
Andrew Scott wrote:
> Ok just been fiddling with a few things and getting no where.
>
> Can someone show me how, here is a sample table
>
> Fields used as a test.
>
> First_Name
> Username
> Password
> Country
> Birth_Date
>
> I wish to have now
>
> Table 1
>
> Username
> Password
>
> Table 2
>
> First_Name
> Last_Name
> Country
> Birth_Date
>
> Just something to get me going would be good, many thanks!!
>
> Regards,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
