# Mysql具體使用 **異步mysql連接池** 例子可參考ServerMysqlTest.php文件 ## 創建表 示例： ```php yield $this->mysql_pool->dbQueryBuilder->coroutineSend(null, " CREATE TABLE IF NOT EXISTS `MysqlTest` ( `peopleid` smallint(6) NOT NULL AUTO_INCREMENT, `firstname` char(50) NOT NULL, `lastname` char(50) NOT NULL, `age` smallint(6) NOT NULL, `townid` smallint(6) NOT NULL, PRIMARY KEY (`peopleid`), UNIQUE KEY `unique_fname_lname`(`firstname`,`lastname`), KEY `fname_lname_age` (`firstname`,`lastname`,`age`) ) ; "); ``` ## 刪除表（直接執行sql語句） 示例： ```php yield $this->mysql_pool->dbQueryBuilder->coroutineSend(null, " DROP TABLE `MysqlTest`; "); ``` ## 插入 示例： ```php $value = yield $this->mysql_pool->dbQueryBuilder->insert('MysqlTest') ->option('HIGH_PRIORITY') ->set('firstname', 'White') ->set('lastname', 'Cat') ->set('age', '25') ->set('townid', '10000') ->coroutineSend(); ``` ## 替換 示例： ```php $value = yield $this->mysql_pool->dbQueryBuilder->replace('MysqlTest') ->set('firstname', 'White') ->set('lastname', 'Cat') ->set('age', '26') ->set('townid', '10000') ->coroutineSend(); ``` ## 修改 示例： ```php $value = yield $this->mysql_pool->dbQueryBuilder->update('MysqlTest') ->set('age', '20') ->where('townid', 10000) ->coroutineSend(); ``` ## Update 字段值的增加/減少 示例： ```php $value = $this->db->update('MysqlTest') ->set("score","score+1",false) ->where('townid', 10000)->coroutineSend(); ``` ## 查詢 示例： ```php $value = yield $this->mysql_pool->dbQueryBuilder->Select('*') ->from('MysqlTest') ->where('townid', 10000, "<") ->orderBy("townid","desc") ->limit(10) ->coroutineSend(); ``` ## 刪除 示例： ```php $value = yield $this->mysql_pool->dbQueryBuilder->delete() ->from('MysqlTest') ->where('townid', 10000) ->coroutineSend(); ``` ## 返回值 [Mysql返回值說明](mysql返回值.md)