newid mysql_oracle 转mysql的newID（）

oracle 创建 newid()

函数

CREATE OR REPLACE FUNCTION "NEWID"

RETURN VARCHAR2

IS

RESULT   VARCHAR2 (40);

BEGIN

SELECT    TO_CHAR (SYSDATE, 'yyyy')

|| TO_CHAR (SYSDATE, 'mm')

|| TO_CHAR (SYSDATE, 'dd')

|| TRIM (to_char(seq_public.NEXTVAL, '0000000000'))

INTO RESULT

FROM DUAL;

--select '2006456456' into Result from dual;

--Result := '2006123123';

RETURN (RESULT);

END newid;

mysql;

CREATE DEFINER = `zc`@`%` FUNCTION `NewProc`()  RETURNS varchar(40) BEGIN     REPLACE INTO `sys_sequence` (`stub`) VALUES ('a');     RETURN (select CONCAT((select DATE_FORMAT(NOW(),'%Y%m%d') from dual),LPAD((SELECT LAST_INSERT_ID()),10,'0')) from dual); END;