依赖
先下载go-sql-driver/mysql:go get -u github.com/go-sql-driver/mysql
数据库
建表:CREATE TABLE `data` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`key` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL,
`value` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL,
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
实现代码:
实体对象func (data Data) String() string { return fmt.Sprintf("id:%d key:%s value:%s\n[createTime:%d updateTime:%d]\n",
data.Id, data.Key, data.Value, data.CreateTime.Unix(), data.UpdateTime.Unix())
}
type Data struct {
Id int64
Key string
Value string
CreateTime time.Time //[]uint8
UpdateTime time.Time //[]uint8}
获得连接db, err := sql.Open("mysql", "dubby:123456@tcp(127.0.0.1:3306)/go_test?parseTime=true")if err != nil {
panic(err.Error())
}
删除func Delete(id int64, db *sql.DB) error {
stmtOut, err := db.Prepare(