Shulou(Shulou.com)06/01 Report--

In fact, it is a very simple operation, but suddenly someone asked me that I just can't remember, so I'll just take a note here.

Mysql > create table test2 (id int (2) AUTO_INCREMENT,name varchar (10), primary key (id))

Query OK, 0 rows affected (0.03 sec)

Mysql > insert into test2 values (null,'a'), (null,'b'), (null,'c')

Query OK, 3 rows affected (0.00 sec)

Records: 3 Duplicates: 0 Warnings: 0

Mysql > select * from test2

+-+ +

| | id | name |

+-+ +

| | 1 | a |

| | 2 | b | |

| | 3 | c |

+-+ +

3 rows in set (0.00 sec)

Mysql > delete from test2 where id in (2pr 3)

Query OK, 2 rows affected (0.00 sec)

Mysql > select * from test2

+-+ +

| | id | name |

+-+ +

| | 1 | a |

+-+ +

1 row in set (0.00 sec)

Mysql > insert into test2 values (null,'d')

Query OK, 1 row affected (0.00 sec)

Mysql > select * from test2

+-+ +

| | id | name |

+-+ +

| | 1 | a |

| | 4 | d | |

+-+ +

2 rows in set (0.00 sec)

Mysql > delete from test2 where id = 4

Query OK, 1 row affected (0.00 sec)

Mysql > alter table test2 AUTO_INCREMENT=2

Query OK, 1 row affected (0.02 sec)

Records: 1 Duplicates: 0 Warnings: 0

Mysql > insert into test2 values (null,'f')

Query OK, 1 row affected (0.00 sec)

Mysql > select * from test2

+-+ +

| | id | name |

+-+ +

| | 1 | a |

| | 2 | f | |

+-+ +

2 rows in set (0.00 sec)

[@ more@]

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.