<small id='X5ueK'></small><noframes id='X5ueK'>

    1. <i id='X5ueK'><tr id='X5ueK'><dt id='X5ueK'><q id='X5ueK'><span id='X5ueK'><b id='X5ueK'><form id='X5ueK'><ins id='X5ueK'></ins><ul id='X5ueK'></ul><sub id='X5ueK'></sub></form><legend id='X5ueK'></legend><bdo id='X5ueK'><pre id='X5ueK'><center id='X5ueK'></center></pre></bdo></b><th id='X5ueK'></th></span></q></dt></tr></i><div id='X5ueK'><tfoot id='X5ueK'></tfoot><dl id='X5ueK'><fieldset id='X5ueK'></fieldset></dl></div>
      <tfoot id='X5ueK'></tfoot>
    2. <legend id='X5ueK'><style id='X5ueK'><dir id='X5ueK'><q id='X5ueK'></q></dir></style></legend>
      • <bdo id='X5ueK'></bdo><ul id='X5ueK'></ul>
      1. 如何随机一个零前导字符串字段mysql

        时间:2024-08-22
            <bdo id='qVtLu'></bdo><ul id='qVtLu'></ul>

            <tfoot id='qVtLu'></tfoot>
              <tbody id='qVtLu'></tbody>
              <legend id='qVtLu'><style id='qVtLu'><dir id='qVtLu'><q id='qVtLu'></q></dir></style></legend>

                <small id='qVtLu'></small><noframes id='qVtLu'>

                1. <i id='qVtLu'><tr id='qVtLu'><dt id='qVtLu'><q id='qVtLu'><span id='qVtLu'><b id='qVtLu'><form id='qVtLu'><ins id='qVtLu'></ins><ul id='qVtLu'></ul><sub id='qVtLu'></sub></form><legend id='qVtLu'></legend><bdo id='qVtLu'><pre id='qVtLu'><center id='qVtLu'></center></pre></bdo></b><th id='qVtLu'></th></span></q></dt></tr></i><div id='qVtLu'><tfoot id='qVtLu'></tfoot><dl id='qVtLu'><fieldset id='qVtLu'></fieldset></dl></div>

                  本文介绍了如何随机一个零前导字符串字段mysql的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我不确定您是否正确理解了我的问题.所以我可以解释一下.我有一个客户表,需要用不同的数字进行测试(无论它是否真实).所以这是脚本:

                  I'm not sure if you understand my question correctly. So may I explain a bit. I have a customer table which is needed to test with different number (no matter if it real). So this is the script:

                  customer_db

                  +----+------------+
                  | ID |   NUMBER   |
                  +----+------------+
                  | 1  | 0812345678 |
                  +----+------------+
                  | 2  | 0812345678 |
                  +----+------------+
                  | 3  | 0812345678 |
                  +----+------------+
                  .
                  .
                  .
                  |100 | 0812345678 |
                  

                  根据表格.我运行了这个脚本:

                  According to the table. I ran this script:

                  UPDATE customer_db SET number = FLOOR(0812345678 + rand()*1000000);
                  

                  这样做.我希望该字段保持与前导081"相同的格式,并随机其余 6 位数字.但事实并非如此.表格变成了这些:

                  Doing this. I expect the field remains the same format with leading '081' and random the rest 6 digits. But it's not. The table becomes these :

                  +----+------------+
                  | ID |   NUMBER   |
                  +----+------------+
                  | 1  | 812246797 |
                  +----+------------+
                  | 2  | 816548798 |
                  +----+------------+
                  | 3  | 815787898 |
                  +----+------------+
                  .
                  .
                  .
                  |100 | 813454687 |
                  

                  它是 9 位而不是 10 位.因为缺少前导 '0'.我应该怎么做才能在随机后保持领先的0".

                  It 9 digits instead of 10. Because the leading '0' is missing. What should I do to remain the leading '0' after the random.

                  推荐答案

                  就像@B-and-P 在他的评论中描述的那样.您可以使用 LPAD 来做到这一点.

                  Like @B-and-P describes in his comment. You can do this using LPAD.

                  UPDATE 
                      customer_db
                  SET
                      number = LPAD(FLOOR(number + rand()*1000000),10,0)
                  

                  LPAD 使用 3 个参数;字符串,字符总数以及最后但并非最不重要的应该使用哪个字符进行填充.

                  LPAD uses 3 parameters; string, total amount of characters and last but not least which character should be used for padding.

                  这篇关于如何随机一个零前导字符串字段mysql的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:如何从 php/mysql 中的清单表中查看/编辑/删除记录 下一篇:在 Yii 中更新查询

                  相关文章

                  <legend id='XPvqO'><style id='XPvqO'><dir id='XPvqO'><q id='XPvqO'></q></dir></style></legend>
                  • <bdo id='XPvqO'></bdo><ul id='XPvqO'></ul>

                    <small id='XPvqO'></small><noframes id='XPvqO'>

                    1. <i id='XPvqO'><tr id='XPvqO'><dt id='XPvqO'><q id='XPvqO'><span id='XPvqO'><b id='XPvqO'><form id='XPvqO'><ins id='XPvqO'></ins><ul id='XPvqO'></ul><sub id='XPvqO'></sub></form><legend id='XPvqO'></legend><bdo id='XPvqO'><pre id='XPvqO'><center id='XPvqO'></center></pre></bdo></b><th id='XPvqO'></th></span></q></dt></tr></i><div id='XPvqO'><tfoot id='XPvqO'></tfoot><dl id='XPvqO'><fieldset id='XPvqO'></fieldset></dl></div>
                      <tfoot id='XPvqO'></tfoot>