본문 : http://www.ischo.net -- 조인상 //시스템 엔지니어
 
+++++++++++++++++++++++++++++++++++++++++++++++++++++++

mysql> select * from xe_member_group;
+----------+-----------+--------------+----------------+------------+----------+------------+-------------+
| site_srl | group_srl | title        | regdate        | is_default | is_admin | image_mark | description |
+----------+-----------+--------------+----------------+------------+----------+------------+-------------+
|        0 |         1 | 관리그룹     | 20100506100444 | N          | Y        |            |             |
|        0 |         2 | 준회원       | 20100506100444 | Y          | N        |            |             |
|        0 |         3 | 정회원       | 20100506100444 | N          | N        |            |             |
+----------+-----------+--------------+----------------+------------+----------+------------+-------------+
3 rows in set (0.00 sec)

mysql> insert into xe_member_group_member
    -> values ('0','1','172','20100512224227');
Query OK, 1 row affected (0.00 sec)

 

 

관리그룹은 1  정회원은 3


mysql> select * from xe_member_group_member;
+----------+-----------+------------+----------------+
| site_srl | group_srl | member_srl | regdate        |
+----------+-----------+------------+----------------+
|        0 |         1 |          4 | xxxxxxxxxx |
|        0 |         2 |          4 | xxxxxxxxxx |
|        0 |         3 |       888 | xxxxxxxxxx |
|        0 |         3 |          4 | xxxxxxxxxx |
|        0 |         3 |          4 | xxxxxxxxxx |
|        0 |         3 |          4 | xxxxxxxxxx |
|        0 |         3 |          4 | xxxxxxxxxx |
|        0 |         3 |       1194 | xxxxxxxxxx |
+----------+-----------+------------+----------------+
8 rows in set (0.00 sec)

 

해서 나온 결과에서 4번멤버가 group_srl이 1 갖고 있으므로

 

888 멤버를 관리그룹으로 만들고 싶으면...

 

mysql> insert into xe_member_group_member
    -> values ('0','1','172','20100512224227');
Query OK, 1 row affected (0.00 sec)