你当然可以把lists:foldl/3 以及lists:join/2 在参数上创建所需的查询格式：

L = [[1, 42],[2, 36], [3,12]],
PreparedList = lists:foldl(fun (Params, Inserts) -> Inserts ++ [io_lib:format("(~p,~p)", Params)]  end, [], L),
%% Then you need to join these with a comma:
Prepared = lists:flatten(lists:join(",", PreparedList)),
%% this will result in "(1,42),(2,36),(3,12)"

现在您只需要调用mysql insert Prepared 变量：

ok = mysql:query(Pid, "INSERT INTO mytable (id, bar) VALUES ?", [Prepared]).
%% The query will look like: "INSERT INTO mytable (id, bar) VALUES (1,42),(2,36),(3,12)"

我不认为这个驱动程序或mysql可以做这样的事情。
我认为你应该像下面这样做

insert_mytable(Data)->
   {ok,Ref} = mysql:prepare(Pid,insert_mytable,"INSERT INTO mytable (id, bar) VALUES (?, ?)"),
   loop_insert(_Pid,Ref,Data).
 loop_insert(_Pid,_Ref,[])-> ok;
 loop_insert(Pid,Ref,[H|T])->
    ok = mysql:execute(Pid,Ref,H),
    loop_insert(Pid,Ref,T).