erlang mnesia表的遍历

1.目的

记录mnesia遍历过程

2.步骤

  1）启动mnesia:

        mnesia:start().

  2) 定义record

       rd(manager, {employee_id, department_id}).

       -record(manager, {employee_id, department_id}).

  3)建表

     mnesia:create_table(manager,
                     [{type, bag},                  %% 反映一对多的关系
                      {attributes, record_info(fields, manager)}]).

  4）插入数据

      8> mnesia:dirty_write(manager,#manager{employee_id=100, department_id=100}).
       ok
      9> mnesia:dirty_write(manager,#manager{employee_id=101, department_id=1000}).
      ok
      10> mnesia:dirty_write(manager,#manager{employee_id=102, department_id=1000}).
      ok
      11> mnesia:dirty_write(manager,#manager{employee_id=103, department_id=1003}).
      ok
      12> mnesia:dirty_write(manager,#manager{employee_id=104, department_id=1004}).

  5)其本操作

     21> mnesia:dirty_first(manager).
102
22> mnesia:dirty_first(102).
** exception exit: {aborted,{bad_type,102}}
     in function  mnesia:abort/1 (mnesia.erl, line 310)
23> mnesia:dirty_next(manager, 102).
100
24> mnesia:dirty_next(manager, 103).
'$end_of_table'
25> mnesia:dirty_next(manager, 100).
101
26> mnesia:dirty_next(manager, 101).
104
27> mnesia:dirty_next(manager, 104).
103
28> mnesia:dirty_next(manager, 103).
'$end_of_table'

 

3.具体操作：

 

4.总结

   mnesia:dirty_first返回的是表的第一个元素。