create table t_xxx_bag2 as select * from t_xxx_bag where 1=0;
可以 用于创建新表,与原表结构一致
"select id from table where 1 = 1"+"and status = #{status}"
where 1 = 1 用于sql语句的拼接时候保证语句的正常查询
create table t_xxx_bag2 as select * from t_xxx_bag where 1=0;
可以 用于创建新表,与原表结构一致
"select id from table where 1 = 1"+"and status = #{status}"
where 1 = 1 用于sql语句的拼接时候保证语句的正常查询