XORM Manual
Introduction
1. Create ORM Engine
2. Define a struct
- 2.1. Name mapping rule
- 2.2. Prefix & Suffix Names
- 2.3. Use Table or Tag to change table or column name
- 2.4. Column define
3. database schema operation
- 3.1. Retrieve database schema infomation
- 3.2. Table Operation
- 3.3. Create indexes and uniques
- 3.4. Sync database schema
4. Insert records
- 4.1. Created
5. Query and Count records
- 5.1. Query condition methods
- 5.2. Temporory methods
- 5.3. Get
- 5.4. Find
- 5.5. Iterate
- 5.6. Count
6. Update records
- 6.1. Optimistic Locking
7. Delete records
8. Execute SQL command
9. Execute SQL query
10. Transaction
11. Cache
12. Events
13. FAQ
14. Xorm Tools
15. Cases
16. Changelog

Powered by GitBook

XORM Manual

9.Execute SQL command

If insert, update or delete then use Exec

sql = "update userinfo set username=? where id=?"
res, err := engine.Exec(sql, "xiaolun", 1)