Mysql实践汇总(不断更新)

    CREATE TABLE `表名` (
      `列名1` int(11) NOT NULL,
      `列名2` varchar(255) NOT NULL,
       ....
      PRIMARY KEY (`主键1`,`主键2`,`主键3`...)，
      KEY `索引名` (`列名1`,`列名2`...) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    tips:
      PRIMARY KEY (`主键1`,`主键2`,`主键3`...)
      KEY `索引名` (`列名1`,`列名2`) USING BTREE
      
      KEY `索引名` (`列名`) USING HASH
      UNIQUE KEY `索引名` (`列名`) USING BTREE
      UNIQUE KEY `索引名` (`列名`) USING HASH