SQL常用指令

1.没有记录则插入，有责更新操作

INSERT INTO tea_store_user(store_id,user_id,point) VALUES('2','1',1)ON DUPLICATE KEY UPDATE point=point+1;

2.根据cust_baseinfo表的cityid查询branch_baseinfo表的所以信息

SELECT * FROM branch_baseinfo bbWHERE bb.cityid IN(  SELECT cb.cityid FROM cust_baseinfo cb WHERE custid='b148245802216443')

2.根据查询结果更新

UPDATE lianjiub_secondactivity ls SET ls.second_count = ls.second_count+1 WHERE ls.said = (SELECT l.said FROM lianjiub_secondorder l WHERE l.requestid='po514963794722969703')