//这是一个内部抓取指定表填充到某个自动SQL字段抓取表的方法。
$db_name='efoa2k';
$tb_name='f1320004';
//function get_column_var($db_name,$tb_name){
$m_sql="SELECT COLUMN_NAME, COLUMN_TYPE, COLUMN_COMMENT
FROM information_schema.columns
WHERE table_schema = '$db_name'
AND table_name = '$tb_name' ";
$m_quy=mysql_query($m_sql,$link1);
$field=1;
echo $m_sql;
//mysql_close($link1);
//$link=mysql_connect($host,$user,$pwd);
//mysql_select_db('syerp');
//mysql_select_db('efoa2k');
//mysql_query('set name utf-8',$link);
//$m_row=mysql_fetch_array($m_quy);
//var_dump($m_row);die();
while($row=mysql_fetch_array($m_quy)){
//echo var_dump($row['COLUMN_COMMENT']);
preg_match_all("/[^\(\)]+/",$row['COLUMN_TYPE'], $row['COLUMN_TYPE']);
$sql="INSERT INTO `efoa2k`.`t110s` (`recordnum`, `file_id`, `s_no`, `field_id`, `field_name`, `data_type`, `field_len`, `decimal_num`, `data_null`, `default_value`, `reference`)VALUES (NULL, '".$tb_name."', '0".$field."', '".$row['COLUMN_NAME']."', '".$row['COLUMN_COMMENT']."','".$row['COLUMN_TYPE'][0][0]."', '".$row['COLUMN_TYPE'][0][1]."', NULL, '', '', NULL) " ;
echo $sql.';<br>';
/*
$quy=mysql_query($sql,$link);
if($quy){
echo 'insert into success';
}else{
echo $field;
die('<br/>'.mysql_error());
}
$field++;
var_dump($row);
*/
}
//}
转载于:https://my.oschina.net/yomut/blog/397423