Golang - 使用Gorm框架执行原生sql
gorm框架执行原生sql有两种方式,作用不同,分别是:
db.exec("sql语句") //执行插入删除等操作使用
db.raw("sql语句") //执行查询操作时使用
举例:
db.Exec("UPDATE orders SET shipped_at=? WHERE id IN (?)", time.Now(), []int64{11,22,33})
db.Raw("SELECT name, age FROM users WHERE name = ?", 3).Scan(&result)
总结:::
https://blog.csdn.net/csde12/article/details/124009100?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522168520447816800227411377%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=168520447816800227411377&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v1~rank_v31_ecpm-7-124009100-null-null.142^v88^control_2,239^v2^insert_chatgpt&utm_term=gorm%20exec&spm=1018.2226.3001.4187&ydreferer=aHR0cHM6Ly9zby5jc2RuLm5ldC9zby9zZWFyY2g%2Fc3BtPTEwMDEuMjEwMS4zMDAxLjQ0OTgmcT1nb3JtJTIwZXhlYyZ0PSZ1PQ%3D%3D