go-sql-driver/mysql 鐃叔プレー鐃緒申鐃循ワ申鐃緒申峇鐃緒申鬟汽檗鐃緒申箸鐃緒申泙鐃緒申鐃�
鐃緒申鐃緒申竜鐃緒申鐃�鐃叔常申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃緒申鐃� go-sql-driver/mysql 鐃祝ドライ鐃緒申側鐃叔のプレー鐃緒申鐃循ワ申鐃緒申峇鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申廛鐃所ク鐃緒申鐃緒申鐃夙わ申个鐃緒申討鐃緒申泙鐃緒申鐃緒申鐃�
鐃緒申鐃曙が鐃殉￥申鐃緒申鐃緒申鐃曙た鐃塾で￥申鐃舜景のわ申鐃緒申鐃初い鐃緒申鐃緒申鐃緒申鐃緒申法鐃緒申匆陲靴討鐃緒申鐃緒申泙鐃緒申鐃�
鐃舜件申
Go 鐃緒申 database/sql 鐃塾鰹申鐃竣につわ申鐃銃わ申鐃緒申鐃緒申竜鐃緒申鐃緒申撚鐃緒申發件申泙鐃緒申鐃緒申鐃�
鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃夙わ申鐃所、 DB.Prepare() 鐃緒申箸錣削申鐃縦常申鐃� DB.Exec() 鐃緒申 DB.Query() 鐃緒申箸辰鐃緒申鐃順、
鐃宿ライ鐃緒申側鐃叔のプレー鐃緒申鐃循ワ申鐃緒申峇鐃緒申鐃緒申弍鐃緒申鐃緒申討鐃緒申覆鐃緒申疋薀わ申个任鐃� prepare, exec, close
鐃緒申3鐃緒申離薀�鐃緒申疋肇鐃獣プわ申発鐃緒申鐃緒申鐃暑こ鐃夙になり、鐃術フワ申鐃緒申鐃殉ンスわ申鐃緒申鐃緒申鐃淑わ申泙鐃緒申鐃�
鐃緒申鐃緒申的鐃祝わ申 DB.Prepare() 鐃緒申箸鐃緒申个鐃緒申鐃緒申里任鐃緒申鐃緒申鐃緒申鐃緒申鐃塾居申鐃緒申鐃叔緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申咼鐃銃ワ申鐃緒申鐃緒申鐃緒申鐃� Go 1.5 鐃祝なわ申泙鐃縦常申鐃殉わ申鐃藷し￥申
IN 鐃順が鐃緒申鐃緒申SQL文鐃淑どで誌申鐃緒申鐃緒申 Prepare 鐃緒申鐃緒申里鐃緒申颪靴鐃緒申鐃緒申鐃緒申鐃緒申鐃粛�鐃緒申泙鐃緒申鐃�
鐃殉わ申鐃緒申O/R鐃殉ッパ￥申鐃巡ク鐃緒申鐃緒申咼鐃緒申鐃緒申鐃緒申箸鐃緒申鐃順、鐃緒申鐃塾ライ鐃瞬ワ申蠅� Prepared Statement 鐃塾ワ申鐃緒申奪鐃緒申鐃緒申鐃出縁申鐃緒申鐃銃わ申鐃淑わ申鐃夙￥申
鐃緒申鐃竣リケ鐃緒申鐃緒申鐃緒申鐃竣ワ申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃叔わ申鐃淑わ申鐃緒申分鐃緒申 DB.Prepare() 鐃緒申箸鐃淑わ申鐃緒申 DB.Query() 鐃緒申鐃夙わ申鐃暑ケ鐃緒申鐃緒申鐃緒申鐃出てわ申鐃殉わ申鐃緒申
鐃緒申鐃順う鐃緒申 prepared statement 鐃薯クワ申鐃緒申鐃緒申鐃緒申鐃夙�鐃峻わ申鐃緒申妊鐃緒申奪箸鐃� 鐃緒申鐃縦わ申鐃緒申
鐃緒申鐃緒申 鐃緒申鐃緒申砲覆辰鐃緒申鐃緒申箸發�鐃所、 go-sql-driver/mysql 鐃祝ワ申鐃竣ワ申鐃緒申鐃緒申鐃緒申与鐃緒申鐃緒申 RFC (Request For Comment)
鐃緒申鐃獣わ申鐃竣ワ申螢�鐃緒申鐃緒申鐃夙わ申鐃殉￥申鐃緒申鐃祝醐申鐃緒申鐃緒申動鐃緒申鐃熟わ申泙鐃緒申鐃緒申鐃�(鐃殉￥申鐃緒申鐃緒申鐃緒申鐃殉でに行っわ申鐃緒申鐃遵ー鐃祝ングにつわ申鐃銃はまわ申鐃緒申鐃緒申匆陲靴茲�鐃夙思わ申鐃殉わ申鐃緒申)
go-sql-driver/mysql 鐃塾プレー鐃緒申鐃循ワ申鐃緒申峇鐃緒申砲弔鐃緒申鐃�
go-sql-drvier/mysql 鐃緒申 go get -u github.com/go-sql-driver/mysql 鐃叔種申鐃緒申鐃緒申鐃殉わ申鐃緒申
鐃殉わ申鐃緒申鐃塾居申能鐃熟マ￥申鐃緒申鐃緒申鐃曙た鐃出わ申鐃緒申覆里如鐃緒申鐃緒申任鐃緒申鐃緒申僂鐃緒申鐃銃わ申鐃緒申鐃緒申鐃熟削申鐃駿わ申鐃塾ワ申鐃殉ワ申匹鐃渋行わ申鐃銃刻申鐃緒申鐃緒申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申
sql.Open() 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申呂鐃� dsl 鐃緒申 interpolateParams=true 鐃夙わ申鐃緒申鐃緒申鐃竣ワ申鐃緒申鐃緒申URL鐃塾ワ申鐃緒申鐃緒申僖鐃潤タ鐃塾件申鐃緒申鐃熟わ申鐃緒申鐃夙にわ申蝓�鐃竣レー鐃緒申鐃循ワ申鐃緒申峇鐃緒申鐃粛�鐃緒申鐃祝なわ申泙鐃緒申鐃�
鐃緒申鐃緒申鐃緒申鐃緒申文鐃緒申鐃緒申鬟┘鐃緒申鐃緒申鐃緒申廚鐃緒申鐃楯にバワ申鐃緒申単鐃縮で緒申鐃緒申鐃緒申鐃銃わ申鐃緒申里如鐃� collation 鐃緒申鐃竣ワ申鐃緒申鐃緒申 cp932 鐃緒申 big5 鐃淑ど器申鐃緒申鐃淑ワ申鐃藷コ￥申鐃叔ワ申鐃藷グわ申鐃緒申蠅件申鐃緒申鐃緒申魯鐃緒申蕁種申砲鐃緒申討鐃緒申泙鐃緒申鐃�
(鐃緒申鐃淑みに￥申 go-sql-driver/mysql 鐃叔ワ申鐃粛ワ申鐃緒申鐃緒申鐃塾ワ申鐃藷コ￥申鐃叔ワ申鐃藷グわ申鐃緒申蠅刻申鐃� charset 鐃緒申鐃竣ワ申鐃緒申鐃緒申鐃緒申箴�鐃淑ので￥申 collation 鐃緒申鐃竣ワ申鐃緒申鐃緒申鐃緒申鐃術わ申鐃銃わ申鐃緒申鐃緒申鐃緒申)
collation鐃熟誌申鐃所し鐃淑わ申鐃緒申鐃叔フワ申鐃緒申箸鐃� utf8_general_ci 鐃叔わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申任鐃� utf8mb4_bin 鐃祝誌申鐃所し鐃銃わ申鐃殉わ申鐃緒申
package main
import (
"database/sql"
"log"
_ "github.com/go-sql-driver/mysql"
)
func main() {
// localhost 鐃緒申 3306 鐃瞬ポ￥申鐃夙わ申動鐃緒申鐃銃わ申鐃緒申 MySQL 鐃祝￥申鐃醇ー鐃緒申鐃緒申名=root, 鐃術ワ申鐃緒ー鐃緒申=password, 鐃叔￥申鐃緒申鐃駿￥申鐃緒申=test 鐃緒申鐃緒申続鐃緒申鐃暑。
// interpolateParams=true 鐃緒申鐃竣ワ申鐃緒申鐃緒申鐃緒申鐃術わ申鐃暑。
db, err := sql.Open("mysql", "root:password@tcp(localhost:3306)/test?interpolateParams=true&collation=utf8mb4_bin")
// 鐃竣レー鐃緒申鐃循ワ申鐃緒申峇鐃緒申鐃峻わ申覆鐃緒申鐃緒申呂鐃緒申鐃緒申鐃�
//db, err := sql.Open("mysql", "root:password@tcp(localhost:3306)/test?collation=utf8mb4_bin")
if err != nil {
log.Fatal(err)
}
if _, err := db.Exec("SELECT SLEEP(?)", 42); err != nil {
log.Fatal(err)
}
}
鐃緒申鐃塾プワ申鐃緒申鐃緒申鐃緒申孫圓鐃緒申討鐃緒申鐃緒申鐃縮のワ申鐃獣ワ申鐃緒申鵑�わ申 SHOW FULL PROCESSLIST 鐃緒申孫圓鐃緒申鐃夙￥申鐃緒申鐃竣ワ申鐃緒申鐃塾醐申鐃縮わ申鐃緒申認鐃叔わ申鐃殉わ申鐃緒申
interpolateParams=true 鐃緒申鐃春わ申鐃淑わ申鐃緒申鐃熟￥申鐃緒申鐃塾よう鐃緒申 Command 鐃緒申 Execute 鐃祝なり、 Info 鐃叔はプレー鐃緒申鐃循ワ申鐃緒申鐃緒申鐃緒申里泙鐃宿緒申鐃緒申鐃緒申鐃殉わ申鐃緒申(鐃夙てもタ鐃緒申鐃淳ングわ申鐃宿わ申鐃緒申弌鐃� Execute 鐃緒申鐃殉ワ申匹鐃緒申鐃淑わ申鐃緒申 Prepare 鐃緒申鐃殉ワ申匹鐃緒申鐃緒申鐃緒申襪�鐃盾し鐃緒申泙鐃緒申鐃�)
mysql> show full processlist; +------+------+-----------------+------+---------+------+------------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------+-----------------+------+---------+------+------------+-----------------------+ | 7508 | root | localhost | NULL | Query | 0 | init | show full processlist | | 7511 | root | localhost:55283 | test | Execute | 2 | User sleep | SELECT SLEEP(?) | +------+------+-----------------+------+---------+------+------------+-----------------------+ 2 rows in set (0.00 sec)
interpolateParams=true 鐃緒申鐃春わ申鐃緒申鐃緒申鐃熟￥申鐃緒申鐃塾よう鐃緒申 Command 鐃緒申 Query 鐃祝なり、 Info 鐃叔プレー鐃緒申鐃循ワ申鐃緒申鐃緒申鐃淑�鐃緒申鐃粛わ申鐃緒申鐃緒申鐃緒申鐃緒申討鐃緒申襪鰹申箸鐃緒申認鐃叔わ申鐃殉わ申鐃緒申
mysql> show full processlist; +----+------+-----------------+------+---------+------+------------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------------+------+---------+------+------------+-----------------------+ | 2 | root | localhost | NULL | Query | 0 | init | show full processlist | | 3 | root | localhost:49283 | test | Query | 1 | User sleep | SELECT SLEEP(42) | +----+------+-----------------+------+---------+------+------------+-----------------------+ 2 rows in set (0.00 sec)
文鐃緒申鐃緒申離鐃緒申鐃緒申鐃緒申鐃緒申廚任蓮鐃� sql_mode 鐃緒申 NO_BACKSLASH_ESCAPES 鐃緒申鐃緒申鐃所し鐃緒申鐃緒申鐃祝わ申鐃出縁申鐃緒申鐃銃わ申鐃殉わ申鐃緒申
鐃緒申鐃塾件申未鐃� db.Exec("SELECT ?, SLEEP(?)", "Hel'lo\nWorld", 42) 鐃緒申鐃緒申鐃緒申鐃塾わ申里任鐃緒申鐃�
mysql> SELECT @@GLOBAL.sql_mode; +-----------------------------------------------------------------+ | @@GLOBAL.sql_mode | +-----------------------------------------------------------------+ | NO_BACKSLASH_ESCAPES,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION | +-----------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> show full processlist; +------+------+-----------------+------+---------+------+------------+-----------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------+-----------------+------+---------+------+------------+-----------------------------------+ | 7515 | root | localhost | NULL | Query | 0 | init | show full processlist | | 7517 | root | localhost:55400 | test | Query | 2 | User sleep | SELECT 'Hel''lo World', SLEEP(42) | +------+------+-----------------+------+---------+------+------------+-----------------------------------+ 2 rows in set (0.00 sec)
@methane
