On Sun, Jan 14, 2001 at 04:13:40PM -0800, Nancy Quesenberry wrote:
> HI,
> I am new to this list and to mySQL.
> 
> I am trying to do a simple copy of a table with the create-select
> and it has a problem with my code. I am using version 3.22.23b. My
> code is:
> 
> create table newtable select * from oldtable;
> 
> Am I missing something? I know I can create the new table and then
> insert into but this create seems so slick, if it would work.

That feature is only availabe in the newer 3.23.xx releases.

> __________________________________________________
> Do You Yahoo!?

I do. :-)

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878    Fax: (408) 530-5454
Cell: (408) 439-9951

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to