I found the comments from a colleague about this:
Hi This is from a run I've made today.
Before the run
AUTO_INCREMENT=776754726
root@host1 [db1]> select max(id) from __old_Arch_MessageData_201101; +-----------+ | max(id) | +-----------+ | 776713349 | +-----------+ 1 row in set (0.00 sec)
After the run :
AUTO_INCREMENT=776713350
root@host1 [db1]> select max(id) from Arch_MessageData_201101; +-----------+ | max(id) | +-----------+ | 776713349 | +-----------+ 1 row in set (0.00 sec)
In this case, I don't think any problem is caused from this. but I'm wondering if there might be cases where it will...
I found the comments from a colleague about this:
Hi
This is from a run I've made today.
Before the run
AUTO_INCREMENT= 776754726
root@host1 [db1]> select max(id) from __old_Arch_ MessageData_ 201101;
+-----------+
| max(id) |
+-----------+
| 776713349 |
+-----------+
1 row in set (0.00 sec)
After the run :
AUTO_INCREMENT= 776713350
root@host1 [db1]> select max(id) from Arch_MessageDat a_201101;
+-----------+
| max(id) |
+-----------+
| 776713349 |
+-----------+
1 row in set (0.00 sec)
In this case, I don't think any problem is caused from this. but I'm wondering if there might be cases where it will...