The CREATE TABLE ` military_umc_organ ` (
` id ` bigint (20) NOT NULL AUTO_INCREMENT,
` umc_organ_code ` varchar (20) NOT NULL,
` mt_organ_code ` varchar (10) NOT NULL,
` create_time ` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (` id `),
The KEY ` organ_id ` (` umc_organ_code `) USING BTREE,
The KEY ` organ_code ` (` mt_organ_code `) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3823 DEFAULT CHARSET=utf8mb4;

The KEY ` organ_id ` (` umc_organ_code `) USING BTREE, the KEY ` organ_id ` (` umc_organ_code `) what meaning be?? USING BTREE is indexed front represent??

CodePudding user response:

Key said after the name of a key, is the column name in brackets, key howkey

CodePudding user response:

Key said after the name of a key, is the column name in brackets, key howkey