Posts Tagged ‘mysql’
MySQL – convert string to auto increment number
07/12/2009
Leave a comment
SELECT
concat(
REPEAT( ‘0’ , ( LENGTH(‘00000’) – LENGTH(CAST(00009 AS UNSIGNED) + 1 ))),
CAST(00009 AS UNSIGNED) + 1
) as str;