往数据库表里添加随机18位数字

UPDATE user_auth SET id_no=RIGHT(user_id, 18) WHERE login_pwd='e10adc3949ba59abbe56e057f20f883e';
UPDATE user_auth_0 SET id_no=RIGHT(user_id, 18) WHERE login_pwd='e10adc3949ba59abbe56e057f20f883e';
UPDATE user_auth_1 SET id_no=RIGHT(user_id, 18) WHERE login_pwd='e10adc3949ba59abbe56e057f20f883e';
UPDATE user_auth_2 SET id_no=RIGHT(user_id, 18) WHERE login_pwd='e10adc3949ba59abbe56e057f20f883e';
UPDATE user_auth_3 SET id_no=RIGHT(user_id, 18) WHERE login_pwd='e10adc3949ba59abbe56e057f20f883e';
UPDATE user_auth_4 SET id_no=RIGHT(user_id, 18) WHERE login_pwd='e10adc3949ba59abbe56e057f20f883e';
UPDATE user_auth_5 SET id_no=RIGHT(user_id, 18) WHERE login_pwd='e10adc3949ba59abbe56e057f20f883e';
UPDATE user_auth_6 SET id_no=RIGHT(user_id, 18) WHERE login_pwd='e10adc3949ba59abbe56e057f20f883e';
UPDATE user_auth_7 SET id_no=RIGHT(user_id, 18) WHERE login_pwd='e10adc3949ba59abbe56e057f20f883e';
UPDATE user_auth_8 SET id_no=RIGHT(user_id, 18) WHERE login_pwd='e10adc3949ba59abbe56e057f20f883e';
UPDATE user_auth_9 SET id_no=RIGHT(user_id, 18) WHERE login_pwd='e10adc3949ba59abbe56e057f20f883e';