MySQLselect、insert、update批量操作语句代码实例

  INSERT INTO SYS_TEXT_PUSH(
      PUSH_ID,
      USER_UM_ACCOUNT,
      USER_NAME,
      SECTION,
      USER_MOBILE,
      PUSH_STATUS,
      PROMOTE_ID,
      CREATED_BY,
      CREATION_DATE,
      ENABLED_FLAG  
)values

  (
    #{item.pushId},
    #{item,userUmAccount},
    #{item.userName},
    #{item.section},
    #{item.userMobile},
    #{item.pushStatus},
    #{item.promoteId},
    #{item.createdBy},
    #{item.creationDate},
    #{item.enabledFlag}
)

  SELECT 
    *
  FROM  SYS_TEXT_PROMOTE 
  WHERE
     TEXT_PUSH_FLAG = 1
    AND  PROMOTE_ID  IN
  
  #{item}

  update
     SYS_TEXT_PUSH
  SET
    PUSH_STATUS = 1,
    LAST_UPDATE_DATE = NOW()
  WHERE
      PUSH_ID  IN

  #{item}

  update
     SYS_TEXT_PUSH
  SET
    PUSH_STATUS = #{item.pushStatus},
    LAST_UPDATE_DATE = NOW()
  WHERE
      PUSH_ID  = #{item.pushId}