At 11:21 -0600 11/13/02, Yuyi Guo wrote:
>Hi,
>
>I am using Mysql version: 3.23.52 on Red Hat Linux.
The option is DATA DIRECTORY, not DATA_DIRECTORY, but in any case it was
introduced in 4.0.0. Your version doesn't support it.
> I tried to create a table as below and got error. Could some one
>point me what I did wrong? Or the DATA DIRECTORY defination does not
>really exist?
>Thanks, Yuyi Guo
>
>mysql> create table testtable2 (col1 varchar(10) NOT NULL, col2
>varchar(10), primary key (col1), index idx1 (col2))
>DATA_DIRECTORY="/tmp";
>ERROR 1064: You have an error in your SQL syntax near
>'DATA_DIRECTORY="/tmp"' at line 1