[erlang-questions] [HEADS UP] Emysql driver

[Barco You]

Solved, the bind-address of mhysql should be changed to 0.0.0.0

But the result packet of emysql:execute looks very verbose and fuzzy. How
can I get only the clean field value or a row, like {field, value} ?

emysql:execute(db_pool, <<"select * from user where tel = 13761975289">>).
{result_packet,11,
               [{field,2,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,
                       <<"userid">>,<<"userid">>,8,<<>>,63,20,16899,0},
                {field,3,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,
                       <<"name">>,<<"name">>,254,<<>>,33,36,20489,0},
                {field,4,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,
                       <<"id_no">>,<<"id_no">>,254,<<>>,33,54,20481,0},
                {field,5,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,
                       <<"sex">>,<<"sex">>,1,<<>>,63,1,0,0},
                {field,6,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,
                       <<"age">>,<<"age">>,2,<<>>,63,6,0,0},
                {field,7,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,
                       <<"tel">>,<<"tel">>,254,<<>>,33,33,0,0},
                {field,8,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,
                       <<"email">>,<<"email">>,253,<<>>,33,132,0,0}],
               [[1,
                 <<231,138,185,230,157,176>>,
                 <<"237689098736789870">>,1,32,<<"13761975289">>,
                 <<"you.jie@REDACTED">>]],
               <<>>}



On Thu, Jul 4, 2013 at 4:21 PM, Max Lapshin <max.lapshin@REDACTED> wrote:

> Barco, it means that you need to read manual for mysql server and
> enable socket listener.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://erlang.org/pipermail/erlang-questions/attachments/20130704/26d831f6/attachment.htm>