21rxTa6B

1DROP DATABASE IF EXISTS `PROFILES`;
2CREATE DATABASE `PROFILES` DEFAULT CHARACTER SET latin1;
3use `PROFILES`;
4
5CREATE TABLE PROFILES.ACQUISITION (
6    Id int(10) unsigned NOT NULL AUTO_INCREMENT,
7    PRIMARY KEY (Id)
8)
9PARTITION BY RANGE COLUMNS(id) (
10       PARTITION p_MAXVALUE VALUES LESS THAN(MAXVALUE)
11       DATA DIRECTORY = 'D:\MyDataBase'
12);
13	
14select * from information_schema.INNODB_SYS_TABLESPACES where name like '%profile%';