mysql> select concat('JXJ-IPC-',00000000);
+-----------------------------+
| concat('JXJ-IPC-',00000000) |
+-----------------------------+
| JXJ-IPC-0 |
+-----------------------------+
1 row in set (0.00 sec)我想得到的结果是JXJ-IPC-00000000
+-----------------------------+
| concat('JXJ-IPC-',00000000) |
+-----------------------------+
| JXJ-IPC-0 |
+-----------------------------+
1 row in set (0.00 sec)我想得到的结果是JXJ-IPC-00000000
用于拼接 例如'JXJ-IPC-00000000'
现在要循环出入数据到'JXJ-IPC-00001000'但是系统默认忽略为0SET pu_id_base='JXJ-IPC-';
SET pu_info_base='IPC_';
SET `index`=00000000;
SET `count`=00000999;
WHILE(`index`<`count`) DO
SET pu_id=concat(pu_id_base,cast(`index` as char));
SET pu_info=concat(pu_info_base,cast(`index` as char));请问如何实现。