# 正常插入:
INSERT INTO tablename (filename, filepath,) value (%s,%s);# 不存在则插入,存在则跳过,即忽略已存在的数据:
INSERT IGNORE INTO tablename (filename, filepath,) value (%s,%s);# 不存在则插入,存在则更新:
REPLACE INTO tablename (filename, filepath,) value (%s,%s);(filename,xmlmd5)
PGSQL
# 正常插入:
INSERT INTO tablename (filename, filepath,) value (%s,%s);# 不存在则插入,存在则跳过,即忽略已存在的数据:
INSERT INTO tablename (filename, filepath,) value (%s,%s) ON CONFLICT (filename) DO nothing;# 不存在则插入,存在则更新:
INSERT INTO tablename (filename, filepath,) value (%s,%s) ON CONFLICT (filename) DO UPDATE SET filename=excluded.filename,filepath=excluded.filenamefilepath;
MYSQL# 正常插入:INSERT INTO tablename (filename, filepath,) value (%s,%s);# 不存在则插入,存在则跳过,即忽略已存在的数据:INSERT IGNORE INTO tablename (filename, filepath,) value (%s,%s);# 不存在则插入,存在则更新:REPLACE INTO tablename (filename, filepath,) value (%s,%s); (filename,xml