day 4 - MySQL Tablespace
create database db1;
use db1;
create table Test1(id int);
CREATE TABLESPACE myspace add datafile 'myspace.ibd';
create table Test2(id int) TABLESPACE=myspace;
mkdir /datafile
chown mysql /data
CREATE TABLESPACE mysecspace add datafile '/data/mysecspace.ibd';
CREATE TABLE Test3(id int) TABLESPACE=mysecspace;
CREATE TABLE Test4(id int) DATA DIRECTORY='/data';
show create table Test1\G;
show create table Test2\G;
show create table Test3\G;
show create table Test4\G;