长字符串的换行有两种方法
- 将每行中的字符串都使用引号括起来, 编译器编译器会将它们拼接起来
- 依旧只使用一个括号,只是每行的末尾使用\来表示换行
m_pDbConnect->SetStatement(
"INSERT INTO playerItemData (Guid, PlayerID, AccountName, ItemID, SlotID, ItemCount) VALUES (?, ?, ?, ?, ?, ?) "
" ON DUPLICATE KEY SET SlotID = ?, ItemCount = ? "
);
m_pDbConnect->SetStatement("\
INSERT INTO playerItemData (Guid, PlayerID, AccountName, ItemID, SlotID, ItemCount) VALUES (?, ?, ?, ?, ?, ?) \
ON DUPLICATE KEY SET SlotID = ?, ItemCount = ?\
");