select a.*, c.name as categoryCodeName from t_work_link a, t_code c where c.groupType='category_code' and a.categoryCode = c.code order by a.seq desc select a.*, c.name as categoryCodeName from t_work_link a, t_code c where a.seq = #{seq} and c.groupType='category_code' and a.categoryCode = c.code insert into t_work_link ( title, categoryCode, linkType, link, memo, updateId, updateDatetime ) values ( #{title}, #{categoryCode}, #{linkType}, #{link}, #{memo}, #{updateId}, now() ) update t_work_link set catecoryCode=#{catecoryCode}, title=#{title}, linkType=#{linkType}, link=#{link}, memo=#{memo}, updateId=#{updateId}, updateDatetime=now() where seq=#{seq}