type User struct {
gorm.Model
Name string
Age string
}
var user User
// works because destination struct is passed in
db.First(&user)
fmt.Println("result: ", user)
// SELECT * FROM `users` ORDER BY `users`.`id` LIMIT 1
我的实例程序
package main
import (
"fmt"
"gorm.io/driver/mysql"
"gorm.io/gorm"
)
type User struct {
gorm.Model
Name string
Age string
}
func main() {
db, err := gorm.Open(mysql.New(mysql.Config{
DSN: "root:@tcp(127.0.0.1:3306)/test2?charset=utf8mb4&parseTime=True&loc=Local", // 账号密码地址端口 // 根据当前 MySQL 版本自动配置
}), &gorm.Config{
// ...gorm配置
})
if err != nil {
panic("failed to connect database")
}
fmt.Println("连接数据库成功")
// 迁移 schema 就是创建一个表,如果已经存在这个表就不会执行这句代码
var user User
db.First(&user)
//db.Where("name = ?", "真的").First(&user)
fmt.Println("result: ", user)
}
结果