mysql 联合查询时当查询条件为空时不作为条件 sql语句写法
Name,Age分别为变量
String sql1 = "select * from book where (name='"+Name+"' or '"+Name+"'='') and (age='"+Age+"' or '"+Age+"'='') ";
Name,Age分别为变量
String sql1 = "select * from book where (name='"+Name+"' or '"+Name+"'='') and (age='"+Age+"' or '"+Age+"'='') ";