13 lines
450 B
Plaintext
13 lines
450 B
Plaintext
--disable_query_log
|
|
set @@session.explicit_defaults_for_timestamp=off;
|
|
--enable_query_log
|
|
|
|
--disable_warnings
|
|
drop table if exists pt1;
|
|
--enable_warnings
|
|
create table pt1 (c1 int primary key, c2 int) partition by key(c1) partitions 3;
|
|
select * from information_schema.partitions where table_name = 'pt1';
|
|
select table_schema, table_name from information_schema.partitions where table_name = 'pt1';
|
|
desc information_schema.partitions;
|
|
drop table pt1;
|