Open orca-zhang opened 2 years ago
orcas 在使用sqlite3+borm过程中发现一些差异：
INSERT IGNORE INTO
INSERT OR IGNORE INTO
FORCE INDEX(idx_name)
INDEXED BY idx_name
ON DUPLICATE KEY UPDATE field1=value1, field2=value2...
ON CONFLICT(field) DO UPDATE SET field1=value1, field2=value2...
*
?
GLOB(field, matcher)
UPDATE
DELETE
LIMIT
LIMIT 2,3
LIMIT 3 OFFSET 2
https://github.com/orca-zhang/borm/tree/sqlite 分支已全部支持
orca-zhang
commented
2 years ago orca-zhang
commented
2 years ago
orcas 在使用sqlite3+borm过程中发现一些差异：
INSERT IGNORE INTO->INSERT OR IGNORE INTOFORCE INDEX(idx_name)->INDEXED BY idx_nameON DUPLICATE KEY UPDATE field1=value1, field2=value2...->ON CONFLICT(field) DO UPDATE SET field1=value1, field2=value2...*和?的模式匹配GLOB(field, matcher)UPDATE/DELETE语句不能添加LIMIT约束LIMIT 2,3->LIMIT 3 OFFSET 2