MYSQL ×Ô¶¯Ôö¼Ó´íÁË

mysql> create table c(id int primary key identity(1,1));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'ident
ity(1,1))' at line 1


create table c(id int primary key identity(1,1)); ÄÄÀïд´íÁË£¿ 

лл´ó¼Ò°ïæ

---

SQL code:
mysql> create table c(id int primary key auto_increment);
Query OK, 0 rows affected (0.08 sec)

mysql> show create table c;
+-------+------------------------------------------------
| Table | Create Table
+-------+------------------------------------------------
| c | CREATE TABLE `c` (
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+------------------------------------------------
1 row in set (0.00 sec)

mysql>

---

ÒýÓÃ

3.6.9. ʹÓÃAUTO_INCREMENT
¿ÉÒÔͨ¹ýAUTO_INCREMENTÊôÐÔΪеÄÐвúÉúΨһµÄ±êʶ£º

CREATE TABLE animals (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (id)
);

INSERT INTO animals (name) VALUES
('dog'),('cat'),('penguin'),
('lax'),('whale'),('ostrich');

SELECT * from animals;
½«·µ»Ø£º