<div dir="ltr">A couple of hints:<div><br></div><div style>Mysql result packets are results from the underlying database. They are defined as records in mysql.hrl which you may want to include in your application.</div><div style>
<br></div><div style>Furthermore, emysql_util contains some convenience-converter-functions which can turn a result into a more erlang-like result which you can then operate on. to_json conversion is in a pull request which I have yet to merge.</div>
<div style><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jul 4, 2013 at 11:12 AM, Barco You <span dir="ltr"><<a href="mailto:barcojie@gmail.com" target="_blank">barcojie@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Where can I find the detailed description about the fields for result_packet?<div><br></div><div>The result_pakcet looks like {result_packet, Number, List1, List2, <<>>}, and seemingly only List2 is meaningful. Why is there Number, List1 and <<>> ?</div>
</div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jul 4, 2013 at 4:37 PM, Barco You <span dir="ltr"><<a href="mailto:barcojie@gmail.com" target="_blank">barcojie@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">What is this part as following for?<div><div><br></div><div><div style="font-family:arial,sans-serif;font-size:13px">
[{field,2,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>
<div style="font-family:arial,sans-serif;font-size:13px"> <<"userid">>,<<"userid">>,8,<<>>,63,20,16899,0},</div><div style="font-family:arial,sans-serif;font-size:13px">
{field,3,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div><div style="font-family:arial,sans-serif;font-size:13px">
<<"name">>,<<"name">>,254,<<>>,33,36,20489,0},</div><div style="font-family:arial,sans-serif;font-size:13px"> {field,4,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>
<div style="font-family:arial,sans-serif;font-size:13px"> <<"id_no">>,<<"id_no">>,254,<<>>,33,54,20481,0},</div><div style="font-family:arial,sans-serif;font-size:13px">
{field,5,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div><div style="font-family:arial,sans-serif;font-size:13px">
<<"sex">>,<<"sex">>,1,<<>>,63,1,0,0},</div><div style="font-family:arial,sans-serif;font-size:13px"> {field,6,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>
<div style="font-family:arial,sans-serif;font-size:13px"> <<"age">>,<<"age">>,2,<<>>,63,6,0,0},</div><div style="font-family:arial,sans-serif;font-size:13px">
{field,7,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div><div style="font-family:arial,sans-serif;font-size:13px">
<<"tel">>,<<"tel">>,254,<<>>,33,33,0,0},</div><div style="font-family:arial,sans-serif;font-size:13px"> {field,8,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>
<div style="font-family:arial,sans-serif;font-size:13px"> <<"email">>,<<"email">>,253,<<>>,33,132,0,0}],</div></div></div></div><div>
<div><div class="gmail_extra">
<br><br><div class="gmail_quote">On Thu, Jul 4, 2013 at 4:35 PM, Barco You <span dir="ltr"><<a href="mailto:barcojie@gmail.com" target="_blank">barcojie@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Solved, the bind-address of mhysql should be changed to 0.0.0.0<div><br></div><div>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} ?</div>
<div><br></div><div><div>emysql:execute(db_pool, <<"select * from user where tel = 13761975289">>).</div><div>{result_packet,11,</div><div> [{field,2,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>
<div> <<"userid">>,<<"userid">>,8,<<>>,63,20,16899,0},</div><div> {field,3,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>
<div> <<"name">>,<<"name">>,254,<<>>,33,36,20489,0},</div><div> {field,4,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>
<div> <<"id_no">>,<<"id_no">>,254,<<>>,33,54,20481,0},</div><div> {field,5,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>
<div> <<"sex">>,<<"sex">>,1,<<>>,63,1,0,0},</div><div> {field,6,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>
<div> <<"age">>,<<"age">>,2,<<>>,63,6,0,0},</div><div> {field,7,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>
<div> <<"tel">>,<<"tel">>,254,<<>>,33,33,0,0},</div><div> {field,8,<<"def">>,<<"fangchan">>,<<"user">>,<<"user">>,</div>
<div> <<"email">>,<<"email">>,253,<<>>,33,132,0,0}],</div><div> [[1,</div><div> <<231,138,185,230,157,176>>,</div>
<div> <<"237689098736789870">>,1,32,<<"13761975289">>,</div><div> <<"<a href="mailto:you.jie@bestv.com.cn" target="_blank">you.jie@bestv.com.cn</a>">>]],</div>
<div> <<>>}</div></div><div><br></div></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jul 4, 2013 at 4:21 PM, Max Lapshin <span dir="ltr"><<a href="mailto:max.lapshin@gmail.com" target="_blank">max.lapshin@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Barco, it means that you need to read manual for mysql server and<br>
enable socket listener.<br>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
erlang-questions mailing list<br>
<a href="mailto:erlang-questions@erlang.org">erlang-questions@erlang.org</a><br>
<a href="http://erlang.org/mailman/listinfo/erlang-questions" target="_blank">http://erlang.org/mailman/listinfo/erlang-questions</a><br>
<br></blockquote></div><br></div>