份份
sql-or与and的配合使用
sql-or与and的配合使⽤关于对sql语句中的or与and,进⾏深⼊解剖⼀:优先级and > or⼆:使⽤场景1.批量修改update*** a set a.is_del =1where a.is_del =0and a.edu_name = ? and a.project_name = ?or a.is_del =0and a.edu_name = ? and a.project_na...
sql-or与and的配合使⽤关于对sql语句中的or与and,进⾏深⼊解剖⼀:优先级and > or⼆:使⽤场景1.批量修改update*** a set a.is_del =1where a.is_del =0and a.edu_name = ? and a.project_name = ?or a.is_del =0and a.edu_name = ? and a.project_na...