just like "update a set a.temp=b.temp from table1 a inner join table2 b on a.ID=b.ID"
or "update user u left join userInfo i on u.uid = i.userId set u.name = 'chen' where u.uid = 1"
Also with delete
jsqlparser useful to me to help group
Log in to post a comment.
just like "update a set a.temp=b.temp from table1 a inner join table2 b on a.ID=b.ID"
or "update user u left join userInfo i on u.uid = i.userId set u.name = 'chen' where u.uid = 1"
Also with delete
jsqlparser useful to me to help group