Supported input formats
-
Single object:
{"name": "张三", "age": 25} -
Object array:
[{"name": "张三"}, {"name": "李四"}]
Database Difference
- MySQL : Support INSERT IGNORE, REPLACE INTO, batch insert
- PostgreSQL : Use ON CONFLICT DO NOTHING
- SQLite : Support INSERT OR IGNORE, INSERT OR REPLACE
- SQL Server : Use square brackets to wrap identifiers
- Oracle : Use INSERT ALL syntax
Notes
- String values will automatically escape single quotes
- A null value produces NULL
- Boolean value converted according to database type
- Nested objects will be converted to JSON strings