테이블 주석

SELECT TABLE_SCHEMA,TABLE_NAME,AUTO_INCREMENT,TABLE_COMMENT
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA='database_name' AND TABLE_NAME='테이블명'


컬럼 주석

SELECT `COLUMN_COMMENT` FROM information_schema.COLUMNS WHERE `TABLE_SCHEMA` ='db명' and TABLE_NAME = '테이블명'
AND `COLUMN_NAME`= '필드명'


ci의 함수로는 없습니다.

답변감사 합니다. 함수로 만들어 써야겠군요.

 한번 만들어 봤습니다. 고견 부탁 드립니다.

==컨트롤==

//member 팝업상세보기
 function popdetail($idxNo)
 {
  $data['col'] = $this->mem_model->column_name();
  $data['row'] = $this->mem_model->kcGetData($idxNo);
  $this->load->view('admin/member/pop_member_detail_view', $data);
 }

==모델==
 function column_name(){ 
   return cN($this->table_name) ;
  }

==헬퍼==
//colum name 자동으로 가져오기

 function cN($table){ 
  $CI = & get_instance();
   $sql="SELECT column_name, column_comment FROM information_schema.columns WHERE table_name='".$table."' "; 
   $query=$CI->db->query($sql); 
  
   foreach ($query->result_array() as $key => $row)   { 
   $column_comment[$row['column_name']]=$row['column_comment']; 
   }

   return $column_comment ;
  }

==뷰==
<?
 $table_name[] = array('userid','passwd','name','level','type','mileage','quest','answer','tel1','tel2','zipcode','addr1','addr2','email','ordcnt','ordsum','adt','bankname','bankregnum','cashback','regnum1','regnum2','com','step','com_sn','ceo','jong1','jong2','comzip','comaddr1','comaddr2','login_count');
?>

<table width="80%" border="0" cellpadding="0" cellspacing="0">
<? for($i=0;$i<count($table_name[0]);$i++){?>
    <tr><td align="left" class='table_input_gubun'> <?=$col[$table_name[0][$i]]?></td><td width="3"></td><td><?=$row[$table_name[0][$i]]?></td></tr><tr height="2"><td colspan="3"></td></tr>  
<?}?>
</table>