Re: create with select

2001-01-14 Thread Jeremy D. Zawodny
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 *

create with select

2001-01-14 Thread Nancy Quesenberry
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