db.exec select failed

[ningmonguo]

`package sqlite_db

import (
"database/sql"
"fmt"
"github.com/glebarez/sqlite"
_ "github.com/mattn/go-sqlite3"
"gorm.io/gorm"
"log"
)

func Sqlite() {
dial := sqlite.Open("sqlite3:example.db")

db, err := gorm.Open(dial)
if err != nil {
	fmt.Println("open dial err, err: ", err)
	return
}

rs, err := db.Exec("select name, age from user").Rows()
if err != nil {
	log.Fatal(err)
	return
}
defer rs.Close()
for rs.Next() {
	var name string
	var age int
	err := rs.Scan(&name, &age)
	if err != nil {
		log.Fatal(err)
	}
	fmt.Println(name, age)
}

}
`

2024/06/04 14:12:04 E:/Study/Goproject/src/test02/sqlite_db/sqlite.go:38 SQL logic error: unrecognized token: "" (1) [0.000ms] [rows:-] SELECT * FROM
2024/06/04 14:12:04 SQL logic error: unrecognized token: "`" (1)