Erlang MySQL client
compile rebar:
- git clone https://github.com/basho/rebar
- cd rebar
- ./bootstrap
compile emysql
- cp rebar emysql/
- cd emysql
- ./rebar compile
- emsysql:select(tab).
- emysql:select({tab, [col1,col2]}).
- emysql:select({tab, [col1, col2], {id,1}}).
- emysql:select(Query, Load).
- emysql:update(tab, [{Field1, Val}, {Field2, Val2}], {id, 1}).
- emsyql:insert(tab, [{Field1, Val}, {Field2, Val2}]).
- emsyql:delete(tab, {name, Name}]).
- emysql:sqlquery("select * from tab;").
- emysql:prepare(find_with_id, "select * from tab where id = ?;").
- emysql:execute(find_with_id, [Id]).
- emysql:unprepare(find_with_id).