emqx4.3/plugins/emysql

emysql

Erlang MySQL client

config

Select API

• emyssql:select(tab).
• emysql:select({tab, [col1,col2]}).
• emysql:select({tab, [col1, col2], {id,1}}).
• emysql:select(Query, Load).

Update API

• emysql:update(tab, [{Field1, Val}, {Field2, Val2}], {id, 1}).

Insert API

• emysql:insert(tab, [{Field1, Val}, {Field2, Val2}]).

Delete API

• emysql:delete(tab, {name, Name}]).

Query API

• emysql:sqlquery("select * from tab;").

Prepare API

• emysql:prepare(find_with_id, "select * from tab where id = ?;").
• emysql:execute(find_with_id, [Id]).
• emysql:unprepare(find_with_id).

MySQL Client Protocal

• http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol