Guest_imported
New member
- Jan 1, 1970
- 0
- 0
- 0
I am trying to create a new table from an existing table, using SELECT.
My command is:
CREATE TABLE test SELECT * FROM atlmar2000 WHERE RankInClass <= 3;
The error I get is:
ERROR 1064: You have an error in your SQL syntax near 'SELECT * FROM atlmar2000 WHERE RankInClass <= 3' at line 1
The SELECT statement by itself works fine.
I have reviewed the MySQL.com documentation, and theoretically this should work.
What is the problem?
My command is:
CREATE TABLE test SELECT * FROM atlmar2000 WHERE RankInClass <= 3;
The error I get is:
ERROR 1064: You have an error in your SQL syntax near 'SELECT * FROM atlmar2000 WHERE RankInClass <= 3' at line 1
The SELECT statement by itself works fine.
I have reviewed the MySQL.com documentation, and theoretically this should work.
What is the problem?
