Kamsi's Blog

MySql

<insert id="insertContent" parameterClass="content">

    <![CDATA[    

INSERT INTO CONTENT (        

CREATED_DATE, TITLE, CONTENT, CONTENT_TYPE    

) VALUES (

        now(), #title#, #content#, #contentType#   

)    

]]>    

<selectKey keyProperty="seqId" resultClass="int">        

SELECT LAST_INSERT_ID()    

</selectKey>

</insert>

MSSQL

<insert id="createProjectBasicInfo" parameterClass="prjIdx">

    <selectKey keyProperty="prj_info_seq" resultClass="int">

       INSERT INTO PRJ_INFO (             ...         ) VALUES (              ...         )        

SELECT SCOPE_IDENTITY()

    </selectKey>

</insert>

Oracle

<insert id="insert_message" parameterClass="java.util.HashMap">    

<selectKey keyProperty="message_id" resultClass="Integer">

        SELECT message_id_seq.nextval FROM DUAL

</selectKey>

INSERT INTO guestbook_message (

message_id, guest_name, password, message

) VALUES(

#message_id#, #gName#, #pw#, #ms#

) 

</insert>

SELECT * FROM TABLE_NAME SAMPLE (3)

SELECT * FROM (

SELECT * FROM TABLE_NAME ORDER BY DBMS_RANDOM.VALUE

)

WHERE ROWNUM < 3 

SELECT TOP 3 * FROM TABLE_NAME ORDER BY NEWID()

SELECT * FROM TABLE_NAME ORDER BY RAND() LIMIT 0,3