insert into MY_TABLE (MY_ID, MY_NAME, MY_CITY) values (#id#, #name#, #city#) select @@IDENTITY; update MY_TABLE set MY_NAME = "name" where MY_ID = #id# delete from MY_TABLE where MY_ID = #id# select MY_ID, MY_NAME, MY_CITY from MY_TABLE where MY_ID = #id# {call myproc(?,?,?)} update MY_TABLE set MY_ID = 9999999 where MY_ID is null