How to create TableSpace

[Nalini R Rajan]

Dear all,

I have Server version 5.1.35-community via TCP/IP and Client version 5.1.11

I have default schema called SuHar

I want to create a TableSpace in that schema.

I used the syntax.

CREATE TABLESPACE core ADD DATAFILE 'suharcore' USE LOGFILE GROUP suharcorelog

It gives error -

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

How do I proceed ?

Thanks for ur help in advance

Regards,
Nalini