copying a table

2001-01-19 Thread Nancy Quesenberry
I too am having trouble with the simple task of copying a table. I am using 3.22.23b. I wanted to use the create with insert but was told this isn't supported by 3.22. So i have created the new table and figured I would use an insert. i can't get this to work either. insert into NewTable

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