테스트 사이트 - 개발 중인 베타 버전입니다

그누5 쪽지보내기에서 여분필드 사용 채택완료

탈환대 11년 전 조회 6,054

 

g5 memo에서 쪽지보내기 보면 글쓴이 아이디랑 제목 내용이 있잖아요 

거기에 항목을 추가해서 여분필드를 사용하고 싶은데 어떤 함수를 사용할수 있는지 궁금합니다. 

wr_1 mb_1 이런 걸로 사용해봐도 안되고 다른 방법이 안떠올라서 질문드립니다. 

 

 

댓글을 작성하려면 로그인이 필요합니다.

답변 2개

채택된 답변
+20 포인트

여분필드라는 개념이 wr_1~10이런것은 게시판에 해당되는것이고

memo에 관련된것이라면 없는것으로 알고 있습니다.

 

 

int(11)  No0 http://localhost/phpMyAdmin/tbl_alter.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&field=me_id" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Change" alt="Change" class="icon ic_b_edit" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -416px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+DROP+%60me_id%60&dropped_column=me_id&message_to_show=Column+me_id+has+been+dropped" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Drop" alt="Drop" class="icon ic_b_drop" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -336px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=SELECT+COUNT%28%2A%29+AS+%60Rows%60%2C+%60me_id%60+FROM+%60g5_memo%60+GROUP+BY+%60me_id%60+ORDER+BY+%60me_id%60" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Browse distinct values" alt="Browse distinct values" class="icon ic_b_browse" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -32px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/themes/dot.gif" title="Primary" alt="Primary" class="icon ic_bd_primary" style="vertical-align: middle; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -320px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+ADD+UNIQUE%28%60me_id%60%29&message_to_show=An+index+has+been+added+on+me_id" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Unique" alt="Unique" class="icon ic_b_unique" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -1104px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+ADD+INDEX%28%60me_id%60%29&message_to_show=An+index+has+been+added+on+me_id" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Index" alt="Index" class="icon ic_b_index" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -576px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/themes/dot.gif" title="Spatial" alt="Spatial" class="icon ic_bd_spatial" style="vertical-align: middle; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -384px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/themes/dot.gif" title="Fulltext" alt="Fulltext" class="icon ic_bd_ftext" style="vertical-align: middle; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -240px !important; background-repeat: no-repeat !important;">
 2varchar(20)utf8_general_ci No  http://localhost/phpMyAdmin/tbl_alter.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&field=me_recv_mb_id" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Change" alt="Change" class="icon ic_b_edit" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -416px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+DROP+%60me_recv_mb_id%60&dropped_column=me_recv_mb_id&message_to_show=Column+me_recv_mb_id+has+been+dropped" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Drop" alt="Drop" class="icon ic_b_drop" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -336px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=SELECT+COUNT%28%2A%29+AS+%60Rows%60%2C+%60me_recv_mb_id%60+FROM+%60g5_memo%60+GROUP+BY+%60me_recv_mb_id%60+ORDER+BY+%60me_recv_mb_id%60" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Browse distinct values" alt="Browse distinct values" class="icon ic_b_browse" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -32px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+DROP+PRIMARY+KEY%2C+ADD+PRIMARY+KEY%28%60me_recv_mb_id%60%29&message_to_show=A+primary+key+has+been+added+on+me_recv_mb_id" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Primary" alt="Primary" class="icon ic_b_primary" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -736px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+ADD+UNIQUE%28%60me_recv_mb_id%60%29&message_to_show=An+index+has+been+added+on+me_recv_mb_id" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Unique" alt="Unique" class="icon ic_b_unique" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -1104px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+ADD+INDEX%28%60me_recv_mb_id%60%29&message_to_show=An+index+has+been+added+on+me_recv_mb_id" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Index" alt="Index" class="icon ic_b_index" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -576px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/themes/dot.gif" title="Spatial" alt="Spatial" class="icon ic_bd_spatial" style="vertical-align: middle; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -384px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+ADD+FULLTEXT%28%60me_recv_mb_id%60%29&message_to_show=An+index+has+been+added+on+me_recv_mb_id" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Fulltext" alt="Fulltext" class="icon ic_b_ftext" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -512px !important; background-repeat: no-repeat !important;">
 3varchar(20)utf8_general_ci No  http://localhost/phpMyAdmin/tbl_alter.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&field=me_send_mb_id" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Change" alt="Change" class="icon ic_b_edit" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -416px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+DROP+%60me_send_mb_id%60&dropped_column=me_send_mb_id&message_to_show=Column+me_send_mb_id+has+been+dropped" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Drop" alt="Drop" class="icon ic_b_drop" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -336px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=SELECT+COUNT%28%2A%29+AS+%60Rows%60%2C+%60me_send_mb_id%60+FROM+%60g5_memo%60+GROUP+BY+%60me_send_mb_id%60+ORDER+BY+%60me_send_mb_id%60" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Browse distinct values" alt="Browse distinct values" class="icon ic_b_browse" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -32px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+DROP+PRIMARY+KEY%2C+ADD+PRIMARY+KEY%28%60me_send_mb_id%60%29&message_to_show=A+primary+key+has+been+added+on+me_send_mb_id" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Primary" alt="Primary" class="icon ic_b_primary" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -736px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+ADD+UNIQUE%28%60me_send_mb_id%60%29&message_to_show=An+index+has+been+added+on+me_send_mb_id" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Unique" alt="Unique" class="icon ic_b_unique" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -1104px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+ADD+INDEX%28%60me_send_mb_id%60%29&message_to_show=An+index+has+been+added+on+me_send_mb_id" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Index" alt="Index" class="icon ic_b_index" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -576px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/themes/dot.gif" title="Spatial" alt="Spatial" class="icon ic_bd_spatial" style="vertical-align: middle; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -384px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+ADD+FULLTEXT%28%60me_send_mb_id%60%29&message_to_show=An+index+has+been+added+on+me_send_mb_id" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Fulltext" alt="Fulltext" class="icon ic_b_ftext" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -512px !important; background-repeat: no-repeat !important;">
 4datetime  No0000-00-00 00:00:00 http://localhost/phpMyAdmin/tbl_alter.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&field=me_send_datetime" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Change" alt="Change" class="icon ic_b_edit" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -416px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+DROP+%60me_send_datetime%60&dropped_column=me_send_datetime&message_to_show=Column+me_send_datetime+has+been+dropped" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Drop" alt="Drop" class="icon ic_b_drop" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -336px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=SELECT+COUNT%28%2A%29+AS+%60Rows%60%2C+%60me_send_datetime%60+FROM+%60g5_memo%60+GROUP+BY+%60me_send_datetime%60+ORDER+BY+%60me_send_datetime%60" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Browse distinct values" alt="Browse distinct values" class="icon ic_b_browse" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -32px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+DROP+PRIMARY+KEY%2C+ADD+PRIMARY+KEY%28%60me_send_datetime%60%29&message_to_show=A+primary+key+has+been+added+on+me_send_datetime" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Primary" alt="Primary" class="icon ic_b_primary" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -736px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+ADD+UNIQUE%28%60me_send_datetime%60%29&message_to_show=An+index+has+been+added+on+me_send_datetime" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Unique" alt="Unique" class="icon ic_b_unique" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -1104px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+ADD+INDEX%28%60me_send_datetime%60%29&message_to_show=An+index+has+been+added+on+me_send_datetime" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Index" alt="Index" class="icon ic_b_index" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -576px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/themes/dot.gif" title="Spatial" alt="Spatial" class="icon ic_bd_spatial" style="vertical-align: middle; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -384px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/themes/dot.gif" title="Fulltext" alt="Fulltext" class="icon ic_bd_ftext" style="vertical-align: middle; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -240px !important; background-repeat: no-repeat !important;">
 5datetime  No0000-00-00 00:00:00 http://localhost/phpMyAdmin/tbl_alter.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&field=me_read_datetime" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Change" alt="Change" class="icon ic_b_edit" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -416px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+DROP+%60me_read_datetime%60&dropped_column=me_read_datetime&message_to_show=Column+me_read_datetime+has+been+dropped" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Drop" alt="Drop" class="icon ic_b_drop" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -336px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=SELECT+COUNT%28%2A%29+AS+%60Rows%60%2C+%60me_read_datetime%60+FROM+%60g5_memo%60+GROUP+BY+%60me_read_datetime%60+ORDER+BY+%60me_read_datetime%60" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Browse distinct values" alt="Browse distinct values" class="icon ic_b_browse" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -32px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+DROP+PRIMARY+KEY%2C+ADD+PRIMARY+KEY%28%60me_read_datetime%60%29&message_to_show=A+primary+key+has+been+added+on+me_read_datetime" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Primary" alt="Primary" class="icon ic_b_primary" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -736px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+ADD+UNIQUE%28%60me_read_datetime%60%29&message_to_show=An+index+has+been+added+on+me_read_datetime" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Unique" alt="Unique" class="icon ic_b_unique" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -1104px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/sql.php?db=g5_love&table=g5_memo&token=d89345cd8eaa6566be33495e07a9a77a&goto=tbl_structure.php&back=tbl_structure.php&sql_query=ALTER+TABLE+%60g5_memo%60+ADD+INDEX%28%60me_read_datetime%60%29&message_to_show=An+index+has+been+added+on+me_read_datetime" style="text-decoration: none; color: rgb(0, 0, 255); cursor: pointer;">http://localhost/phpMyAdmin/themes/dot.gif" title="Index" alt="Index" class="icon ic_b_index" style="vertical-align: middle; border: 0px; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -576px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/themes/dot.gif" title="Spatial" alt="Spatial" class="icon ic_bd_spatial" style="vertical-align: middle; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -384px !important; background-repeat: no-repeat !important;">http://localhost/phpMyAdmin/themes/dot.gif" title="Fulltext" alt="Fulltext" class="icon ic_bd_ftext" style="vertical-align: middle; margin: 0px; width: 16px; height: 16px; padding: 0px !important; background-image: url(http://localhost/phpMyAdmin/themes/original/img/sprites.png) !important; background-position: 0px -240px !important; background-repeat: no-repeat !important;">
 6

이런식으로 구성이 되어 있네요.

 

추가적으로 me_1 이라던지 추가를 하셔서 사용을 하시는게 맞으실것같습니다.

로그인 후 평가할 수 있습니다

답변에 대한 댓글 1개

탈환대
11년 전
db에 me_1 을 추가하고 sql_write.sql 에도 추가했는데 안나오는데 뭐가 문제인거죠? ㅠㅠ
me_recv_mb_id 이 함수는 잘 출력이 됩니다.

댓글을 작성하려면 로그인이 필요합니다.

어떻게 불러오셧는데 않되시는건가요 ?

mysql에서 입력하신 정보값이 me_1에 찍혀 있나요 ?

찍혀 있지 않다면 입력 부분이 에러이실것이구요

 

찍혀 있음에도 출력이 않되면, 출력 부분에 대해 잘 못하신거구요

로그인 후 평가할 수 있습니다

댓글을 작성하려면 로그인이 필요합니다.

답변을 작성하려면 로그인이 필요합니다.

로그인