mysql的id自动编号,如何复原到原始? 我想id自动编号的这个列,复原到0,重新开始。如何弄哦?现在是编号到100多。。想重新0开始~ 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 mysql> CREATE TABLE `test`.`tb` ( -> `Id` int(6) unsigned NOT NULL auto_increment, -> title varchar(20), -> PRIMARY KEY (`Id`) -> );Query OK, 0 rows affected (0.13 sec)mysql> insert into tb(title) values('title');Query OK, 1 row affected (0.06 sec)mysql> insert into tb(title) values('title2');Query OK, 1 row affected (0.08 sec)mysql> select * from tb;+----+--------+| Id | title |+----+--------+| 1 | title || 2 | title2 |+----+--------+2 rows in set (0.00 sec)mysql> delete from tb;Query OK, 2 rows affected (0.07 sec)mysql> ALTER TABLE tb AUTO_INCREMENT=1;Query OK, 0 rows affected (0.31 sec)Records: 0 Duplicates: 0 Warnings: 0mysql> insert into tb(title) values('title');Query OK, 1 row affected (0.07 sec)mysql> select * from tb;+----+-------+| Id | title |+----+-------+| 1 | title |+----+-------+1 row in set (0.00 sec)mysql> 类的继承问题 为什么数据写不进数据库 代码求效率优化 php 上传出错了 帮忙看看 PHP一个缓存设置的问题,请大家帮我解释一下,谢谢 javascript传值给php在ff中可以,在ie中不可以,为什么? 问个问题~~~~~~~PHP+SERV-U的~~~ 关于mp3在线播放 请教:一个机器上为啥出现N多个PHP进程? 请教JavaScript中有没有能调用外部程序的函数?类似PHP中的exec(),system(). 在ie8下,打开兼容性视图位置就下降了,帮小弟看下,谢谢了 求一个用PHP操作一个记录数组的PHP文件。
mysql> CREATE TABLE `test`.`tb` (
-> `Id` int(6) unsigned NOT NULL auto_increment,
-> title varchar(20),
-> PRIMARY KEY (`Id`)
-> );
Query OK, 0 rows affected (0.13 sec)mysql> insert into tb(title) values('title');
Query OK, 1 row affected (0.06 sec)mysql> insert into tb(title) values('title2');
Query OK, 1 row affected (0.08 sec)mysql> select * from tb;
+----+--------+
| Id | title |
+----+--------+
| 1 | title |
| 2 | title2 |
+----+--------+
2 rows in set (0.00 sec)mysql> delete from tb;
Query OK, 2 rows affected (0.07 sec)
mysql> ALTER TABLE tb AUTO_INCREMENT=1;
Query OK, 0 rows affected (0.31 sec)
Records: 0 Duplicates: 0 Warnings: 0mysql> insert into tb(title) values('title');
Query OK, 1 row affected (0.07 sec)mysql> select * from tb;
+----+-------+
| Id | title |
+----+-------+
| 1 | title |
+----+-------+
1 row in set (0.00 sec)mysql>