Creating a table via SELECT - Why the syntax error?

[Guest_imported]

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?

 

[Guest_imported]

Answer: I am using MySQL 3.22, and this syntax is only supported from version 3.23.

 

[ravikumar]

i have tried to load table with a .txt file using the following option . But it says file not found

LOAD DATA LOCAL INFILE &quot;pet.txt&quot; INTO TABLE pet;

i get a error message saying 'pet.txt' not found.

how do i get around this .

But Insert command is working.