kohana直接执行query写法sql语句

// Create a new SELECT query
$query = DB::query(Database::SELECT, 'SELECT * FROM users');
 
// Create a new DELETE query
$query = DB::query(Database::DELETE, 'DELETE FROM users WHERE id = 5');

// Create a new UPDATE query
$query = DB::query(Database::DELETE, 'UPDATE users SET title=3 WHERE id = 5');

最后要加上执行语句：

$result = $query->execute();

$query = DB::insert('users', array('username', 'password'))->values(array('fred', 'p@5sW0Rd'));
INSERT INTO `users` (`username`, `password`) VALUES ('fred', 'p@5sW0Rd')


$query = DB::update('users')->set(array('username' => 'jane'))->where('username', '=', 'john');
UPDATE `users` SET `username` = 'jane' WHERE `username` = 'john'


$fields = array('cityname', 'pinyin', 'py', 'p');
$query = DB::insert('city', $fields);
foreach($data as $k=>$v)
{
$query->values($v);
}
$query->execute();

echo $query;
return $query;

$result为受影响的数据库记录数。

http://www.kofans.org/3.2/guide/database/query/builder#insert