>
> Of course if that doesn't work the OP might try
>
> CREATE TABLE x AS
> SELECT * FROM y;
>
> TRUNCATE TABLE y;
>
> INSERT INTO y
> SELECT * FROM x;
>
> DROP TABLE x;
>
> But sthg is far more efficient. Why I used it last night several times
> after drinking a bit of single malt. And I've had no complaints so far.
>
Oh, come on and give me a break. Please tell me is it possible to do this
without truncating table. I just want to know how to do this.
Thanks
Received on Sun Aug 24 2003 - 02:35:50 CDT
