id, version,iosVersion,android_name,android_download,android_update,ios_update select version,iosVersion,android_name,android_download,android_update,ios_update from sys_version where id = #{id,jdbcType=INTEGER} delete from sys_version where id = #{id,jdbcType=INTEGER} insert into sys_version (id, version) values (#{id,jdbcType=INTEGER}, #{version,jdbcType=VARCHAR}) insert into sys_version id, version, #{id,jdbcType=INTEGER}, #{version,jdbcType=VARCHAR}, update sys_version version = #{version,jdbcType=VARCHAR}, where id = #{id,jdbcType=INTEGER} update sys_version set version = #{version,jdbcType=VARCHAR} where id = #{id,jdbcType=INTEGER} select version,android_name,android_download,android_update,createDate from sys_version where version=#{version,jdbcType=VARCHAR} order by createDate desc limit 1; select version,android_name,android_download,android_update,createDate from sys_version where android_name=#{version,jdbcType=VARCHAR} order by createDate desc limit 1; select iosVersion,ios_update,createDate from sys_version where iosVersion=#{iosVersion,jdbcType=VARCHAR} order by createDate desc limit 1; insert into sys_version id, version, android_name, android_download, android_update, createDate, #{id,jdbcType=INTEGER}, #{version,jdbcType=VARCHAR}, #{androidName}, #{androidDownload}, #{androidUpdate}, #{createDate}, insert into sys_version id, iosVersion, ios_update, createDate, #{id,jdbcType=INTEGER}, #{iosVersion,jdbcType=VARCHAR}, #{iosUpdate}, #{createDate}, select iosVersion,ios_update from sys_version WHERE iosVersion ]]>'' order by createDate DESC LIMIT 1 select version,android_name,android_download,android_update from sys_version WHERE version ]]>'' ORDER BY createDate DESC LIMIT 1 select version,android_name,android_download,android_update from sys_version WHERE createDate > #{createDate} select iosVersion,ios_update from sys_version WHERE createDate > #{createDate}