create table cbb_tdf.test_ger1(a int) data directory=‘D:/code/general’;

mysql使用通用表空间_sql

create tablespace ger_space add datafile 'D:/code/general/ger_space.ibd' file_block_size=16384;


select * from information_schema.innodb_sys_tablespaces where name = 'ger_space'\G;

create table cbb_tdf.test_ger2(a int) tablespace=ger_space;