原生操作
写原生语句
select
player := Player{}
q := db.RawQuery("SELECT * FROM players WHERE id = ?", 1)
err := q.Find(&player, id)
Update
err := db.RawQuery("UPDATE players SET instrument = ? WHERE id = ?", "guitar", 1).Exec()
Delete
err := db.RawQuery("DELETE FROM players WHERE id = ?", 1).Exec()
在RawQuery中依然可以使用占位的方式传输变量,避免出现SQL注入漏洞。