DB table 컬럼 비교 정보
DB table 컬럼 비교본문
컬럼이 비슷한 테이블을 비교합니다.
<?php
include '_common.php';
$get_constant = 'constant';
$this_db= G5_MYSQL_DB;
?>
<div >
<form >
<input type="text" name="tbl1" value="<?=$tbl1?>" placeholder="table1" />
<input type="text" name="tbl2" value="<?=$tbl2?>" placeholder="table2" />
<input type="submit" />
</form>
</div>
<?php
if( $tbl1 & $tbl2 ) {
echo '<table>';
$sql="SELECT a.COLUMN_NAME acols, b.COLUMN_NAME bcols FROM INFORMATION_SCHEMA.COLUMNS a left join INFORMATION_SCHEMA.COLUMNS b
on a.TABLE_name='{$tbl1}' and b.TABLE_NAME='{$tbl2}'
and a.COLUMN_NAME=b.COLUMN_NAME
WHERE a.TABLE_SCHEMA = '{$get_constant('G5_MYSQL_DB')}' AND a.TABLE_NAME = '{$tbl1}'
union
SELECT a.COLUMN_NAME acols, b.COLUMN_NAME bcols FROM INFORMATION_SCHEMA.COLUMNS a right join INFORMATION_SCHEMA.COLUMNS b
on a.TABLE_name='{$tbl1}' and b.TABLE_NAME='{$tbl2}'
and a.COLUMN_NAME=b.COLUMN_NAME
WHERE b.TABLE_SCHEMA = '{$get_constant('G5_MYSQL_DB')}' AND b.TABLE_NAME = '{$tbl2}'
";
$result= sql_query( $sql);
$ins_set=array();
$sel_set=array();
echo '<table>';
if( $result) while( $row= sql_fetch_array( $result)) {
$ins_set[]= $row['acols']?$row['acols']:"''";
$sel_set[]= $row['bcols']?$row['bcols']:"''";
echo '<tr><td bgcolor="'.($row['acols']?'':'#d3f9d8').'" >',$row['acols'],'</td><td bgcolor="'.($row['bcols']?'':'#d3f9d8').'" >',$row['bcols'],'</td></tr>';
}
echo '</table>';
echo 'ok';
}
2