Gorm Returning Data From Deleted Rows failed

Your Question

Why did my code for testing Returning failed?

s := "%s:%s@tcp(%s)/%s?charset=%s&parseTime=%t&loc=Local"
s1 := fmt.Sprintf(s, "root", "12345678", "127.0.0.1:3306", "test_data", "utf8", true)
db, err := gorm.Open(mysql.Open(s1))
if err != nil {
return
}

//temp := User{}
us := make([]User, 10)
l := db.Clauses(clause.Returning{}).Where("role = ?", "user").Delete(&us).RowsAffected
fmt.Println(l) //output: 3
fmt.Println(us) // output: []

Comment From: a631807682

mysql does not support the returning syntax