Open
Description
CREATE TABLE test1
(
id
bigint(20) NOT NULL COMMENT '主键ID',
bill_type
tinyint(2) NOT NULL DEFAULT '1' COMMENT '',
collect_no
varchar(32) NOT NULL DEFAULT '' COMMENT '',
create_time
timestamp NULL DEFAULT NULL COMMENT '',
PRIMARY KEY (id
) USING BTREE,
KEY f_idx_bgt
((cast(create_time
as date)))
) ENGINE=InnoDB
KEY f_idx_bgt
((cast(create_time
as date)))
After testing, this index is recognized as a column
I used 1.7 and 1.8
Metadata
Metadata
Assignees
Labels
No labels