ETC
SQLite Upsert Query
NicSub
2024. 5. 8. 18:52
728x90
반응형
Create Table SaveChat
(
ChatDate Date ,
ChatVar varchar(20),
ChatName varchar(50),
ChatCount Integer,
Constraint tb_product_group_PK Primary Key(ChatDate,ChatName)
)
------------------------------------------------------------------------------------
INSERT INTO SaveChat (ChatDate, ChatVar, ChatName, ChatCount)
VALUES (@ChatDate, @ChatVar, @ChatName, @ChatCount)
ON CONFLICT(ChatDate, ChatName) DO UPDATE SET ChatCount = ChatCount + 1
WHERE ChatDate = @ChatDate AND ChatName = @ChatName;
반응형