in xa/basic/insert.go [28:42]
func insertData(ctx context.Context) error {
sql := "INSERT INTO `order_tbl` ( `user_id`, `commodity_code`, `count`, `money`, `descs`) VALUES (?, ?, ?, ?, ?);"
ret, err := db.ExecContext(ctx, sql, "NO-100001", "C100000", 100, nil, "init desc")
if err != nil {
fmt.Printf("insert failed, err:%v\n", err)
return err
}
rows, err := ret.RowsAffected()
if err != nil {
fmt.Printf("insert failed, err:%v\n", err)
return err
}
fmt.Printf("insert success: %d.\n", rows)
return nil
}