1.检查表是否存在
->SHOW TABLES LIKE $tablename;
看是否有值返回
2.
/*
取得所有相关表名
*/
function get_alllog_tables()
{
global $_gDb;
$queryl = "SHOW TABLES LIKE 'log_%'";
$_gDb->query($queryl);
while($_gDb->next_record()) {
$tables[] =$_gDb->Record[0];
}
return $tables;
}
3.获取表名 concat()
SELECT count(*) as cnt,concat('log_fj_2012-02') as tabname FROM `log_fj_2012-02` WHERE 1=1
4.将一个数据表的数据插入另一个表
insert into internet_machine_group (
select '',rule_name from internet_rule
)
5.取得Unix系统时间戳
$sql = "SELECT *, UNIX_TIMESTAMP()-UNIX_TIMESTAMP(TS.create_time) AS times FROM tab_sys_machine_stat TS INNER JOIN pt_connectlist PC ON TS.comm_code=PC.unit_id WHERE PC.type=0";
6.rename database db1 to db2; 修改数据库名字