事务操作transaction

$db->transaction();
$data = [
'title' => 'new title',
'status' => 2
];
$db->table('test')->where('id', 10)->update($data);
$db->commit();
# 回滚
$db->rollBack();

分析表analyze

$db->table('users')->analyze();
# 输出: "ANALYZE TABLE users"

检查表check

$db->table(['users', 'pages'])->check();
# 输出: "CHECK TABLE users, pages"

校验checksum

$db->table(['users', 'pages'])->checksum();
# 输出: "CHECKSUM TABLE users, pages"

优化表optimize

$db->table(['users', 'pages'])->optimize();
# 输出: "OPTIMIZE TABLE users, pages"

修复表repair

$db->table(['users', 'pages'])->repair();
# 输出: "REPAIR TABLE users, pages"