MYSQL现在的值前頭加個0的辦法

update `tbl_student` set `student_id`=CONCAT('0',`student_id`), `student_login`=CONCAT('0',`student_login`) where student_id NOT LIKE '0%' AND student_login NOT LIKE '0%';