1# 2# MariaDB-5.3 format 3# 4SET @@global.mysql56_temporal_format=false; 5CREATE TABLE t1 (a DATETIME NOT NULL, b DATETIME NOT NULL); 6INSERT INTO t1 VALUES ('2001-01-01 10:10:10','2001-01-01 10:10:10'); 7SELECT * FROM t1; 8a b 92001-01-01 10:10:10 2001-01-01 10:10:10 10SELECT (AVG_ROW_LENGTH-1) DIV 2 AS FIELD_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1'; 11FIELD_LENGTH DATA_LENGTH 128 17 13DROP TABLE t1; 14CREATE TABLE t1 (a DATETIME(5) NOT NULL, b DATETIME(5) NOT NULL); 15INSERT INTO t1 VALUES ('2001-01-01 10:10:10.12345','2001-01-01 10:10:10.12345'); 16SELECT (AVG_ROW_LENGTH-1) DIV 2 AS FIELD_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1'; 17FIELD_LENGTH DATA_LENGTH 187 15 19SELECT * FROM t1; 20a b 212001-01-01 10:10:10.12345 2001-01-01 10:10:10.12345 22DROP TABLE t1; 23CREATE TABLE t1 (a TIME(5) NOT NULL,b TIME(5) NOT NULL); 24INSERT INTO t1 VALUES ('10:10:10.12345','10:10:10.12345'); 25SELECT * FROM t1; 26a b 2710:10:10.12345 10:10:10.12345 28SELECT (AVG_ROW_LENGTH-1) DIV 2 AS FIELD_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1'; 29FIELD_LENGTH DATA_LENGTH 305 11 31DROP TABLE t1; 32# 33# MySQL-5.6 format 34# 35SET @@global.mysql56_temporal_format=true; 36CREATE TABLE t1 (a DATETIME NOT NULL, b DATETIME NOT NULL); 37INSERT INTO t1 VALUES ('2001-01-01 10:10:10','2001-01-01 10:10:10'); 38SELECT * FROM t1; 39a b 402001-01-01 10:10:10 2001-01-01 10:10:10 41SELECT (AVG_ROW_LENGTH-1) DIV 2 AS FIELD_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1'; 42FIELD_LENGTH DATA_LENGTH 435 11 44DROP TABLE t1; 45CREATE TABLE t1 (a DATETIME(5) NOT NULL, b DATETIME(5) NOT NULL); 46INSERT INTO t1 VALUES ('2001-01-01 10:10:10.12345','2001-01-01 10:10:10.12345'); 47SELECT * FROM t1; 48a b 492001-01-01 10:10:10.12345 2001-01-01 10:10:10.12345 50SELECT (AVG_ROW_LENGTH-1) DIV 2 AS FIELD_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1'; 51FIELD_LENGTH DATA_LENGTH 528 17 53DROP TABLE t1; 54CREATE TABLE t1 (a TIME(5) NOT NULL,b TIME(5) NOT NULL); 55INSERT INTO t1 VALUES ('10:10:10.12345','10:10:10.12345'); 56SELECT * FROM t1; 57a b 5810:10:10.12345 10:10:10.12345 59SELECT (AVG_ROW_LENGTH-1) DIV 2 AS FIELD_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1'; 60FIELD_LENGTH DATA_LENGTH 616 13 62DROP TABLE t1; 63SET @@global.mysql56_temporal_format=DEFAULT; 64