Re: question

[Paul DuBois]

At 8:54 AM +0800 2000-01-11, Lh´Ì wrote:
>Hello:
>my os is linux red hat 6.1
>mysql is 3.22.23b
>I want to use template table
>so I use this....
>mysql>use DB_name;
>mysq>create table tmptbl TYPE=HEAP select ip, date from t1_table;
>ERROR 1064  you have an error in your  SQL syntax near'TYPE=HEAP select
>ip,date from t1_table;' at line 1
>
>why?
>I see this sql statement on document (mysql reference manual for version
>3.22.23b) 10.17 MySQL table type. ....
>HEAp.......


The HEAP (and MYISAM) table storage types are not available until
MySQL 3.23.

-- 
Paul DuBois, paul@stripped