添加字段方案:
include "mysql.inc";
$db_id = mysql_connect($CF_DB_HOST, $CF_DB_USER, $CF_DB_PWD);
mysql_select_db($CF_DB_NAME,$db_id);
set_time_limit(0);
$sql = "select focusid from siteinfo";
$rs = mysql_query($sql,$db_id);
while($row = mysql_fetch_row($rs)){
$focusid = $row[0];
$tsql = "describe misprintlog_".$focusid." correctword";
$tqry = mysql_query($tsql);
$field = mysql_fetch_row($tqry);
if($field[0]){
echo "字段已经存在";
}
else{
$tempsql = "alter table misprintlog_".$focusid." add correctword varchar(255) default ''";
echo $tempsql."\n";
mysql_query($tempsql,$db_id);
}
}