我在一个表中有两个字段（标题、内容）并插入了一些值…：
+--------------------------------------+--------------------------+
| title | content |
+--------------------------------------+--------------------------+
| hello word | this is my first content |
+--------------------------------------+--------------------------+
| smoke Smoking is bad for your health | But i love it |
+--------------------------------------+--------------------------+
如果我添加一个名为ID的自动递增字段，则先前的输入值采用ID=0：
+---+--------------------------------------+--------------------------+
|ID | title | content |
+---+--------------------------------------+--------------------------+
| 0 | hello word | this is my first content |
+---+--------------------------------------+--------------------------+
| 0 | smoke Smoking is bad for your health | But i love it |
+---+--------------------------------------+--------------------------+
我需要这个：
+---+--------------------------------------+--------------------------+
|ID | title | content |
+---+--------------------------------------+--------------------------+
| 1 | hello word | this is my first content |
+---+--------------------------------------+--------------------------+
| 2 | smoke Smoking is bad for your health | But i love it |
+---+--------------------------------------+--------------------------+
将正确的ID设置为旧值的唯一方法是php+foreach？或者我忘记了使用sql/mysql来更快地自动获取正确的ID值？
谢谢你的帮助。
最佳答案
好吧，现在是我帮你的时候了：P。
您将SQL代码放入php页面或phpmyadmin在线代码编辑器中？有时phpmyadmin在线编辑器会失败，请在php页面中尝试它，它可以正常工作。