mysql - 自动增加 MySQL 注册表

Question

我的数据库中有一个包含 15 条记录的表示例：

--------table---------
P000112018082800.00A |
P000112018082800.00A |
P000112018082800.00A |
P000112018082800.00A |
P000112018082800.00A |
P000112018082800.00A |
P000112018082800.00A |
P000112018082800.00A |
P000112018082800.00A |
P000112018082800.00A |
P000112018082800.00A |
P000112018082800.00A |
P000112018082800.00A |
P000112018082800.00A |
P000112018082800.00A |

在 P0001 最后一个数字之后，我希望它可以自动递增，以便从结果到此。

P0001
P0002
P0003
P0004
P0005
P0006
P0007
P0008
P0009
P0010
P0011
P0012
P0013
P0014
P0015

所以结果必须是这样

------------餐桌完成------------

    P000112018082800.00A
    P000212018082800.00A
    P000312018082800.00A
    P000412018082800.00A
    P000512018082800.00A
    P000612018082800.00A
    P000712018082800.00A
    P000812018082800.00A
    P000912018082800.00A
    P001012018082800.00A
    P001112018082800.00A
    P001212018082800.00A
    P001312018082800.00A
    P001412018082800.00A
    P001512018082800.00A

有任何想法吗？

标签： mysql