??????????
????MyBatis??update?????÷???insert????????????????????????????????????????update??????sql???????SQL????????MyBatis?????????????
????????????????????????????????????????У???????????????????????
????????MSSQL??SQL???
????WITH R AS??
????SELECT 'John' as name?? 18 as age?? 42 as  id
????UNION ALL
????SELECT 'Mary' as name?? 20 as age?? 43 as  id
????UNION ALL
????SELECT 'Kite' as name?? 21 as age?? 44 as  id
??????
????UPDATE TStudent SET name = R.name?? age = R.age
????FROM R WHERE R.id = TStudent.Id
????????MSSQL??ORACLE??MySQL??SQL???
????UPDATE TStudent SET Name = R.name?? Age = R.age
????from (
????SELECT 'Mary' as name?? 12 as age?? 42 as id
????union all
????select 'John' as name ?? 16 as age?? 43 as id
????) as r
????where ID = R.id
???????SQLITE??SQL???
???????????￡?
????REPLACE INTO TStudent(Name?? Age?? ID)
????VALUES('Mary'?? 12?? 42)
???????????￡?
????REPLACE INTO TStudent(Name?? Age?? ID)
????SELECT * FROM (
????select 'Mary' as a?? 12 as b?? 42 as c
????union all
????select 'John' as a?? 14 as b?? 43 as b
????) AS R
?????????REPLACE INTO???????????????????INSERT????????UPDATE??????
?????塢???
??????????MyBatis????????ORM????????????????SQL?????????????á??????????SQL?????????????????????????????????????Щ???ж??η?????????????