有一个表,表结构如下:Table:t1CreateTable:CREATETABLE`t1`(`id`smallint(5)unsignedNOTNULLAUTO_INCREMENT,`username`varchar(45)NOTNULL,`regdate`datetimeNOTNULL,`order`smalli...
有一个表,表结构如下:
Table: t1
Create Table: CREATE TABLE `t1` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(45) NOT NULL,
`regdate` datetime NOT NULL,
`order` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `order` (`order`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8
其中id位主键,order为唯一索引。
表中有三条记录:
mysql> select * from t1;
+----+----------+---------------------+-------+
| id | username | regdate | order |
+----+----------