query to change length of autoincrement

[critical5]

I have a table and with an increment ID which id now SN001 but i would like to add an extra 0 to make it SN0001...any idea how to do this??

I tried update like this
UPDATE CUSTOMERS
SET CUSTOMER_ID = "DL0+[CUSTOMER_ID,4]"

Thanks

 

[critical5]

SORRY I WANT TO DO THIS IN MYSQL