只有用存储过程自己写
*****************************************************************************
欢迎使用CSDN论坛阅读器 : CSDN Reader(附全部源代码)
http://www.cnblogs.com/feiyun0112/archive/2006/09/20/509783.html
*****************************************************************************
欢迎使用CSDN论坛阅读器 : CSDN Reader(附全部源代码)
http://www.cnblogs.com/feiyun0112/archive/2006/09/20/509783.html
CREATE PROCEDURE `test`.`getID` ()
BEGIN
DECLARE prefix CHAR(2); <-- prefix
DECLARE num CHAR(5); <-- 0001
DECLARE p CHAR(2);
DECLARE tem CHAR(15); DECLARE cur_1 CURSOR FOR SELECT pos FROM test ORDER BY pos DESC LIMIT 0,1;
DECLARE CONTINUE HANDLER FOR NOT FOUND; SET prefix = 'CS';
SET p = DATE_FORMAT(CURDATE(), '%y');
OPEN cur_1;
FETCH cur_1 INTO tem;
SET tem = SUBSTRING(tem, 4, 4);
.................
..................
..........
END $$DELIMITER ;
写了一半,有事要走,没空写了。看谁帮着改改吧、