Code:
CREATE TABLE `moja` (
`ID` INT(11) DEFAULT NULL,
`A` DOUBLE(20,4) DEFAULT NULL,
`B` DOUBLE(20,4) DEFAULT NULL,
`C` DOUBLE(20,4) DEFAULT NULL,
INDEX prvi (A,B)
) ENGINE=MYISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC
INDEX DIRECTORY = 'D:\mysql\index'
DATA DIRECTORY='D:\mysql'
Code:
(0 row(s) affected, 2 warning(s))
Execution Time : 00:00:00:078
Transfer Time : 00:00:00:000
Total Time : 00:00:00:078
Warning Code : 1618
<DATA DIRECTORY> option ignored
Warning Code : 1618
<INDEX DIRECTORY> option ignored
i opet mi sve file-ove kreira po default-u.
u ini file dodana linija
keep_files_on_create=ON
pod sekciju MyIsam