tamsun <tamsun@gmail.com> wrote in
news:f1gcf299gkpta5h69tikqr4h040vl1rb9t@4ax.com:

>
> hi, I have a question:
>
> I hava a table, such as:
>
> Table: T1
> Field:
> ID varchar(38),
> VALUE varchar(4000),
>
> Now I need modify table structure to:
> Table: T2
> Filed:
> ID varchar(38),
> VALUE long raw
>
> My question is:
> As filed "VALUE" had be changed to long raw,
> how to move old record into new table T2 by SQL,
> e.g. how to insert a string(such as "Hello World")
> into long raw filed by pure sql.
>

INSERT INTO T2 SELECT * FROM T1;