- 论坛徽章:
- 0
|
回复 #1 huangruihua 的帖子
1。请教一下:如何在两台已经安装MYSQL的机器上进行数据库的联系,需要怎么样配置啊?
----------------------------------------------------------------------------------------------------------
这个我没懂你的意思,可否理解为需要数据交互?
===========================================================
2。还有一个问题是,我建了一个表,其中主键是auto_increment,那删除记录,再重新Insert 记录的时候,主键一直往上加。比如我有四个记录,我删除了第四个记录,再添加一个记录,这个记录的主键就是5了.我想让它的主键还是4,该怎么处理啊?
----------------------------------------------------------------------------------------------------------------------------------
| auto_increment_id | CREATE TABLE `auto_increment_id` (
`id` mediumint(9) NOT NULL auto_increment,
`name` char(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
-----------------------------------------------------------------------------------------
mysql> select * from auto_increment_id;
+----+----------+
| id | name |
+----+----------+
| 1 | gogo407 |
| 2 | happy |
| 3 | beijing |
| 4 | shanghai |
| 7 | changsha |
| 8 | nanjing |
+----+----------+
6 rows in set (0.00 sec)
-----------------------------------------------------------------------------------------------
mysql> insert into auto_increment_id values ('5','shanghai');
-----------------------------------------------------------------------------------------------
mysql> select * from auto_increment_id;
+----+----------+
| id | name |
+----+----------+
| 1 | gogo407 |
| 2 | happy |
| 3 | beijing |
| 4 | shanghai |
| 7 | changsha |
| 8 | nanjing |
| 5 | shanghai |
+----+----------+
7 rows in set (0.00 sec)
-----------------------------------------------------------------------------------------
也就是说直接给auto_increment就可以了
呵呵,写的真详细,lz抽时间还是看看手册好了:) |
|