Gorm After mysql is updated, return the updated value, using variables

Execute native sql, define variables, and return the updated value

native sql

UPDATE admin_account SET created_at = @created_at := created_at+1 WHERE id=3; SELECT @created_at as value;

gorm wrong wording

    tx := m.orm.Begin()
    defer func() {
        if r := recover(); r != nil {
            tx.Rollback()
        }
    }()

    var values int64
    sql2 := "UPDATE admin_account SET created_at = @created_at := created_at+1 WHERE id=3; SELECT @created_at as value;"
    err := tx.Raw(sql2).Pluck("value", &values).Error
    if err != nil {
        //todo
    }

Expected answer

Right way ？？

Comment From: github-actions[bot]

The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨