mysql_insert_id()寻找上一次插入的id

来源:互联网 发布:matlab生成无标度网络 编辑:程序博客网 时间:2024/05/16 15:09

例子:

 $query_batch = 'INSERT INTO table_change_log_batch (BatchTableName,BatchOperator,BatchComments,BatchCreationTime,BatchAction,BatchPrimaryKeyValue) 
               VALUES ("'.$table_name.'","'.$user.'","'.$BatchComments.'","'.$timeNow.'","EDIT","0")';
        
       
        mysql_query($query_batch);
        $select = mysql_insert_id();//$select[0]就是最后插入的id值了,mysql_insert_id()必须紧接在insert或者update之后执行
    

0 0