sql
青鸟飞云
软件工程师
展开
-
sql常用
1、在一张表中插入这张表中没有的记录insert into SA_CENTRAL(KEYWORD,SEGMENTS,CENTRAL,CENTRAL_TYPE) (select distinct ?,?,?,? from DUAL WHERE NOT EXISTS (SELECT ID,KEYWORD FROM SA_CENTRAL WHERE lower(KEYWORD) =原创 2017-09-06 19:31:06 · 403 阅读 · 0 评论 -
case when else end语句
SELECT PARENT_BRAND,CHILD_BRAND,(CASE WHEN SOURCE = '' THEN 'HIVE' else SOURCE end)SOURCE FROM ps_child_parent_brand原创 2017-10-30 17:43:28 · 238 阅读 · 0 评论 -
KEYWORD为主键,要是插入的数据主键一样,则更新ISBOOK
INSERT INTO SA_WARM_BOOK_CACHE(KEYWORD,ISBOOK) VALUES(?,?) ON DUPLICATE KEY UPDATE ISBOOK=?原创 2017-10-30 17:44:57 · 184 阅读 · 0 评论