ADADADADAD

关于修改AUTO_INCREMENT列的默认值的测试[ mysql数据库 ]

mysql数据库时间：2024-12-03 12:15:00

作者：文/会员上传

如何提高mysql查询效率

简介：

其实是个很简单的操作，但是忽然有人问我就是想不起来，暂且做个笔记在这里。mysql> create table test2(id int(2) AUTO_INCREMENT,name varchar(10),primary key(id));
Query

以下为本文的正文内容，内容仅供参考！本站为公益性网站，复制本文以及下载DOC文档全部免费。

其实是个很简单的操作，但是忽然有人问我就是想不起来，暂且做个笔记在这里。

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: 3Duplicates: 0Warnings: 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 (2,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: 1Duplicates: 0Warnings: 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@]

将本文的Word文档下载到电脑

热门标签: inc改

申请https需要什么条件