Am Fre, 2003-06-27 um 15.29 schrieb Dani Oderbolz:
> greg(at)turnstep(dot)com wrote:
>
> > ...
> >
> >
> >If you have already created the "MirrorHosts" table and do not want to
> >lose the data inside it, you could do this:
> >
> >CREATE TABLE mirrorhosts AS SELECT * FROM mirrorhosts
ALTER TABLE products RENAME TO items;
At least with 7.3.2
HTH
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de