修改 my.ini

[mysqld]
port=3306
character-set-server=utf8
default_authentication_plugin=mysql_native_password
[mysql]
default-character-set=utf8
[client]
default-character-set=utf8

最后重启 mysql

truncate table xx

step 1

阅读全文

group_actionid 表

actionid 表

阅读全文

function strQuery($sql){
    $sql = mysql_query($sql);
    $resule = array();
    while($row = mysql_fetch_assoc($sql)){
        $result[] = $row;
    }
    $str = "";
    foreach($result as $key => $val){
        $str = $str.implode("-", $val)."|"; 
    }
    $data = substr($str, 0, strlen($str)-1);
    return $data;
}

member 表: uuid, username.
people 表: uuid, name.

阅读全文