Basic Syntax
Create Single Record
Data Types
Multiple Fields
With Timestamps
Bulk Insert
Insert multiple records at once. Each record is wrapped in square brackets with= assignments.
Upsert
Insert or update if exists. Specify conflict field(s) withON.
Upsert with Composite Key
Replace
Delete and insert (MySQL-specific behavior).Complete Examples
User Registration
E-commerce Order
Bulk Product Import
Next Steps
Update Data
Modify existing records
Delete Data
Remove records

