insert into Account SET
	Relation = 11,
	Company = "whats";

package main
import (
	"context"
	"database/sql"
	"fmt"
	"log"
	"github.com/andrei-dascalu/api/accounts"
	_ "github.com/go-sql-driver/mysql"
)
func main() {
	ctx := context.Background()
	db, err := sql.Open("mysql", "root:root@tcp(127.0.0.1:3306)/gotest")
	if err != nil {
		log.Fatal(err)
	}
	acctData := accounts.New(db)
	accounts, err := acctData.ListAccounts(ctx)
	if err != nil {
		log.Fatal(err)
	}
	for _, item := range accounts {
		fmt.Printf("%d\n", item.Relation.Int64)
	}
}

2023年09月03日 19:18:30 sql: Scan error on column index 3, name "exceedoeinidate": unsupported Scan, storing driver.Value type []uint8 into type *time.Time

CREATE TABLE `Account` (
 `Id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `Relation` bigint(20) unsigned DEFAULT NULL,
 `Company` varchar(50) DEFAULT NULL,
 `ExceedOEIniDate` date DEFAULT '2017年01月01日',
 `CreateDate` datetime DEFAULT CURRENT_TIMESTAMP,
 `ModifyDate` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- name: ListAccounts :many
SELECT * FROM Account
ORDER BY CreateDate DESC;

version: 1
packages:
 - path: "accounts"
 name: "accounts"
 engine: "mysql"
 schema: "schema/schema.sql"
 queries: "queries/queries.sql"