From: Beyond The Curb
Date: October 2 2000 2:44pm
Subject: Coping Tables!
List-Archive: http://lists.mysql.com/internals/16
Message-Id: <009301c02c7f$47db5880$6bf4d33f@computer>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0090_01C02C4C.FC0B27A0"

------=_NextPart_000_0090_01C02C4C.FC0B27A0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

This maybe somewhat of a dumb question but I am having the worst time =
figuring out how to copy tables. =20
This is the string I was using:

CREATE TABLE new_table_name SELECT * FROM old_table_name; also
CREATE TABLE new_table_name SELECT * FROM old_table_name WHERE 1 =3D 0;
and mysql says error in syntax at 'select * from etc.'

I had to build an exact replica the old fashioned way but would love to =
be able to copy in one simple string,=20
Are you even able to copy tables now and if so how or what am I doing =
wrong?=20

Any help would be appreciated.
THANK YOU!
Trisha=20

------=_NextPart_000_0090_01C02C4C.FC0B27A0--

_______________________________________________
Why pay for something you could get for free?
NetZero provides FREE Internet Access and Email
http://www.netzero.net/download/index.html