2018/04/20 简单的SQL语句

查询语句

SELECT * FROM project_shipment ps
WHERE ps.company_id = 39 AND (ps.shipping_time BETWEEN '2018-02-10' and '2018-04-20')

查询满足搜索条件的数据个数：

SELECT COUNT(*) FROM ifct_bake_former
WHERE times >= 1

更新语句

UPDATE project_shipment SET company_id = 32 
WHERE project_shipment.company_id is NULL

插入语句

insert into project_assort
( no, company_id,  create_time,  status, address )values (111,39,now(),0,'陕西省西安市长安区' )

删除语句

DELETE FROM project_shipment 
WHERE project_shipment.company_id != 39 AND (project_shipment.shipping_time BETWEEN '2018-02-10' and '2018-04-20')