github.com/gogf/gf@v1.16.9/.example/database/gdb/mysql/gdb_update_union.go (about)

     1  package main
     2  
     3  import (
     4  	"fmt"
     5  
     6  	"github.com/gogf/gf/frame/g"
     7  )
     8  
     9  func main() {
    10  	db := g.DB()
    11  	db.SetDebug(true)
    12  	result, err := db.Table("pw_passageway m,pw_template t").Data("t.status", 99).Where("m.templateId=t.id AND m.status = 0").Update()
    13  	if err != nil {
    14  		panic(err)
    15  	}
    16  	fmt.Println(result.RowsAffected())
    17  }