test.go

package main

import (
	"database/sql"
	"fmt"

	_ "github.com/go-sql-driver/mysql"
)

func main() {
    db, err := sql.Open("mysql", "root:@tcp(127.0.0.1:4000)/test?charset=utf8")
	if err != nil {
		panic(err)
	}
	defer db.Close()

	stmt, err := db.Prepare("select timediff('1:1:1.001', cast('1:1:1' as datetime))")
	if err != nil {
		panic(err)
	}
	defer stmt.Close()

	rt, err := stmt.Query()
	if err != nil {
		panic(err)
	}
	defer rt.Close()

	for rt.Next() {
		var s interface{}
		err = rt.Scan(&s)
		if err != nil {
			panic(err)
		}
		fmt.Println(s)
	}

	fmt.Println("Prepare over.")

	rt , err = db.Query("select timediff('1:1:1.001', cast('1:1:1' as datetime))")
	if err != nil {
		panic(err)
	}
	defer rt.Close()

	for rt.Next() {
		var s interface{}
		err = rt.Scan(&s)
		if err != nil {
			panic(err)
		}
		fmt.Println(s)
	}

	fmt.Println("None Prepare over.")

}