mysql 자동증가

sel_dt||LPAD(ROW_NUMBER() OVER( PARTITION BY sel_dt ORDER BY ROWNUM ), 3, '0')

SELECT NAME
             ,SEQ
            ROW_NUMBER() OVER ( ORDER BY SEQ) AS NEWSEQ 
    FROM TEST

http://whiterussian.tistory.com/entry/SELECT-%EA%B2%B0%EA%B3%BC%EC%97%90-%ED%96%89-%EB%B2%88%ED%98%B8-%EC%9E%90%EB%8F%99%EC%9C%BC%EB%A1%9C-%EB%A7%A4%EA%B8%B0%EA%B8%B0

select @SEQ := @SEQ+1 AS SEQ from mk_board tt,(SELECT @SEQ := 0) sqe  where tt.brd_code='bukgu63' and tt.del='0' limit 0,15