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
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