SQL error

[Leadrive]

[SELECT create_at, id, read_flag, message, relation_field, relation_id, remark
FROM user_messages
WHERE user_id = ? AND read_flag = ? AND valid = 1 ORDER BY create_at DESC LIMIT ?, ? 114820 0 0 20] file="inform.go:169" id=0
ERRO[2019-04-22 00:05:03] Received #1064 error from MySQL server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0', '20'' at line 3"

I use database/sql and github.com/ziutek/mymysql/godrv
this is a simple sql, why report error?

[Leadrive]

the same sql, in github.com/go-sql-driver/mysql, it will work ok.

[ziutek]

What are "114820 0 0 20"? Probably arguments to this query.

It seems that the following text is sent to the MySQL server:

SELECT create_at, id, read_flag, message, relation_field, relation_id, remark
FROM user_messages
WHERE user_id = ? AND read_flag = ? AND valid = 1 ORDER BY create_at DESC LIMIT ?, ? 114820 0 0 20

and MySQL server parser complains near ''0', '20''.

You don't provide any real code that sends this query so I can't tell much more.

If you use database/sql the go-sql-driver is probably better option for you.

MyMySQL is rather intended to use without database/sql for MySQL specific applications.