按时间随机获取单据码
SELECT CONCAT('SET',(SELECT REPLACE(REPLACE(REPLACE(now(),'-',''),':',''),' ','')))
SELECT
CONCAT(
'SQID',
DATE_FORMAT(now(), '%Y%m%d%H%i%s'),
lpad(round(round(rand(),4)*1000),4,'0')
) from `setsq`;