简单SQL语句举例

‌select t2_je from t2;    最简单的查询select * into tab2_bak from tab2;  备份一个表select * from t2 where t2_lsbh in('111','1111') ; 带条件的查询select * from t2 where t2_lsbh ='111' or t2_lsbh='1111' ; 等同于上个查询比较符   like in  not  条件逻辑关系  and  or select * from t2 where t2_lsbh like'1111%';  like用法 select * from t3; Update t3 set t3_dz