엑

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개

감사합니다
저에게도 도움이 될 것 같습니다
댓글을 작성하시려면 로그인이 필요합니다.
+
제목 글쓴이 날짜 조회
21-06-20 조회 9,934
21-06-20 조회 7,837
21-06-19 조회 8,923
21-06-17 조회 8,968
21-06-16 조회 1.1만
21-06-15 조회 9,460
21-06-15 조회 9,571
21-06-15 조회 9,404
21-06-15 조회 8,765
21-06-14 조회 8,594
21-06-14 조회 7,819
21-06-10 조회 1.2만
21-06-09 조회 7,967
21-06-08 조회 9,776
21-06-08 조회 8,285
21-06-08 조회 8,297
21-06-07 조회 9,055
21-06-06 조회 8,061
21-06-04 조회 7,812
21-06-04 조회 8,495
21-06-03 조회 1.1만
21-06-02 조회 7,808
21-06-02 조회 8,449
21-06-01 조회 7,840
21-05-31 조회 8,847
21-05-31 조회 8,334
21-05-30 조회 7,307
21-05-28 조회 9,895
21-05-27 조회 8,905
21-05-26 조회 8,688