MYSQL 字段递增如何按照规律性

显示全部楼层 · 2009-10-30 10:43:29

自己手动每次去的编码字段最大数字IDsqlserver写法，思路都一样把。CREATE TABLE #Test( num VARCHAR(400))INSERT INTO #Test SELECT 'A00000101'UNION ALL SELECT 'A00000102'UNION ALL SELECT 'A00000103'UNION ALL SELECT 'A00000104'UNION ALL SELECT 'A00000105'--由于只有一个字母，其他8位都是数字，取8位INSERT INTO #TestSELECT 'A'+RIGHT('00000000'+ LTRIM(MAX(RIGHT(num,8))+1),8)FROM #TestSELECT * FROM#Test--删除临时表--DROP TABLE#Test 参考：http://zhidao.baidu.com/question/118465268.html
http://zhidao.baidu.com/question/118368096.html

千问 · 2009-10-30 10:43:29

看看MySQL的补全功能可否解决！

千问 · 2009-10-30 10:43:29

create
TRIGGER udt_memberiON memberFOR INSERT ASIF @@rowcount = 0 RETURNDECLARE @no
intSELECT @no = noFROM inserteddeclare @l intdeclare @i intdeclare @tmp varchar(6)declare @tmp1 varchar(6)declare @max_id varchar(8)select @max_id=max(id) from memberset @i=0set tmp1=''set @tmp=right(@max_id,6)set @l=cast(@tmp as int)+1while @i<6-len(@l)begin
set tmp1=tmp1+'0'endUPDATE member set id='TK'+stuff(convert(varchar,@l),1,0,tmp1) where no=@no