package main
import (
"database/sql"
"log"
_ "github.com/go-sql-driver/mysql" // or the driver of your choice
"github.com/joho/sqltocsv"
)
type Post struct {
ID string
Post_title string
}
func main() {
db, err := sql.Open("mysql", "root:12345@tcp(127.0.0.1:3306)/db_test")
if err != nil {
log.Fatal("Failed to open a DB connection: ", err)
}
defer db.Close()
rows, err := db.Query(`
SELECT * FROM wp_post p
`)
var myPost Post
var count int
for rows.Next() {
err := rows.Scan(&myPost.ID, &myPost.Post_title)
if err != nil {
log.Fatal(err)
}
count += 1
fmt.Println(count, "PostID:", myPost.ID, myPost.Post_title)
}
err = sqltocsv.WriteFile("export.csv", rows)
if err != nil {
panic(err)
}
}