CREATE TABLE `tabname` (
`id` int NOT NULL AUTO_INCREMENT,
`id_pc` varchar(255) DEFAULT NULL COMMENT 'aaaaa',
`first` varchar(255) DEFAULT NULL COMMENT '第一个',
`second` varchar(255) DEFAULT NULL COMMENT '第二个',
`third` varchar(255) DEFAULT NULL COMMENT '第三个',
`num` int DEFAULT NULL COMMENT '值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23055 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='数据表'
SHOW ENGINES; -- 提供的引擎
Engine |
Support |
Comment |
Transactions |
XA |
Savepoints |
FEDERATED |
NO |
Federated MySQL storage engine |
NULL |
NULL |
NULL |
MEMORY |
YES |
Hash based, stored in memory, useful for temporary tables |
NO |
NO |
NO |
InnoDB |
DEFAULT |
Supports transactions, row-level locking, and foreign keys |
YES |
YES |
YES |
PERFORMANCE_SCHEMA |
YES |
Performance Schema |
NO |
NO |
NO |
MyISAM |
YES |
MyISAM storage engine |
NO |
NO |
NO |
MRG_MYISAM |
YES |
Collection of identical MyISAM tables |
NO |
NO |
NO |
BLACKHOLE |
YES |
/dev/null storage engine (anything you write to it disappears) |
NO |
NO |
NO |
CSV |
YES |
CSV storage engine |
NO |
NO |
NO |
ARCHIVE |
YES |
Archive storage engine |
NO |
NO |
NO |
网友评论