mysql主键必定是唯一索引------顺便用实例说说索引的创建

       创建表：

CREATE TABLE `tbtest` (    
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT 'student id',    
  `name` VARCHAR(32) NOT NULL COMMENT 'student name',    
  `score` INT UNSIGNED NOT NULL DEFAULT '0' COMMENT 'student score'  
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='student tb'

        看下：

mysql> show create table tbtest;
+--------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table  | Create Table