构建kohana复杂的sql语句
来源:互联网 发布:u盘烧了数据恢复 编辑:程序博客网 时间:2024/05/29 02:17
Selecting only specific columns
DB::select('column1','column2')->from('table_name');
SELECT `column1`, `column2` FROM `table_name`
Selecting Column AS
DB::select(array('column','my_column'))->from('table_name')->compile($db);
SELECT `column` AS `my_column` FROM `table_name`
join()
DB::select()->from('table_name')->join('table_2')->on('table_2.table_id', '=', 'table_name.id');
SELECT * FROM `table_name` JOIN `table_2` ON `table_2`.`table_id` = `table_name`.`id`
group_by()
DB::select()->from('table_name')->group_by('column');
SELECT * FROM `table_name` GROUP BY `column`
DB::select()->from('table_name')->group_by(array('column1', 'mycol'));
SELECT * FROM `table_name` GROUP BY `column1` AS `mycol`
having()
DB::select()->from('table_name')->having('column','=','value');
SELECT * FROM `table_name` HAVING `column` = 'value'
and_having()
DB::select()->from('table_name')->having('column','=','value')->and_having('column2','=','value');
SELECT * FROM `table_name` HAVING `column` = 'value' AND `column2` = 'value'
or_having()
DB::select()->from('table_name')->having('column','=','value')->or_having('column2','=','value');
SELECT * FROM `table_name` HAVING `column` = 'value' OR `column2` = 'value'
having_open()
DB::select()->from('table_name')->having_open()->having('column','=','value')
->or_having('column2','=','value')->having_close();
SELECT * FROM `table_name` HAVING (`column` = 'value' OR `column2` = 'value')
and_having_open()
DB::select()->from('table_name')->where('column','=','value')->and_having_open()->having('column2','=','value')
->and_having('column3','=','value')->and_having_close();
SELECT * FROM `table_name` WHERE `column` = 'value' HAVING (`column2` = 'value' AND `column3` = 'value')
or_having_open()
DB::select()->from('table_name')->where('column','=','value')->or_having_open()->having('column2','=','value')
->or_having('column3','=','value')->or_having_close();
SELECT * FROM `table_name` WHERE `column` = 'value' HAVING (`column2` = 'value' OR `column3` = 'value')
order_by()
DB::select()->from('table_name')->order_by('column', 'ASC');
SELECT * FROM `table_name` ORDER BY `column` ASC
limit()
DB::select()->from('table_name')->limit(10);
SELECT * FROM `table_name` LIMIT 10
offset()
DB::select()->from('table_name')->limit(10)->offset(50);
SELECT * FROM `table_name` LIMIT 10 OFFSET 50
where()
DB::select()->from('table_name')->where('column','=','value');
SELECT * FROM `table_name` WHERE `column` = 'value'
and_where()
DB::select()->from('table_name')->where('column','=','value')->and_where('column2','=','value');
SELECT * FROM `table_name` WHERE `column` = 'value' AND `column2` = 'value'
or_where()
DB::select()->from('table_name')->where('column','=','value')->or_where('column2','=','value');
SELECT * FROM `table_name` WHERE `column` = 'value' OR `column2` = 'value'
where_open()
DB::select()->from('table_name')->where_open()->where('column','=','value')
->or_where('column2','=','value')->where_close();
SELECT * FROM `table_name` WHERE (`column` = 'value' OR `column2` = 'value')
and_where_open()
DB::select()->from('table_name')->where('column','=','value')->and_where_open()->where('column2','=','value')
->or_where('column3','=','value')->and_where_close();
SELECT * FROM `table_name` WHERE `column` = 'value' AND (`column2` = 'value' OR `column3` = 'value')
or_where_open()
DB::select()->from('table_name')->where('column','=','value')->or_where_open()->where('column2','=','value')
->and_where('column3','=','value')->or_where_close();
SELECT * FROM `table_name` WHERE `column` = 'value' OR (`column2` = 'value' AND `column3` = 'value')
阅读全文
0 0
- 构建kohana复杂的sql语句
- kohana中在ORM中组装比较复杂的SQL
- 复杂的sql语句
- 复杂的sql语句
- 较复杂的sql语句
- kohana直接执行query写法sql语句
- oracle的复杂sql语句复习
- 一些略微复杂的sql语句
- 今天写的一段复杂sql语句
- SQL复杂查询语句的使用
- sql语句复杂查询的思路
- 条件复杂的sql语句查询
- 一条比较复杂的update sql语句
- SQL复杂查询语句
- 复杂SQL语句
- 复杂sql语句
- mysql 复杂sql语句
- SQL复杂语句
- 面试中常见的集合类问题
- 使用全注解配置Spring MVC+Spring +MyBatis框架,带事务配置。
- leetcode 330. Patching Array 最小的添加/删除次数使sum为1到n
- Qt笔记_4
- Pointcut is not well-formed: expecting 'name pattern' at character position
- 构建kohana复杂的sql语句
- SPOJ Smart Network Administrator(二分+网络流)
- 调制(2)——带通调制(载波调制)
- ubuntu 16.04 成功安装有道词典
- linux关于文件处理的命令
- JAVA十六进制(包含小数)和二进制互转
- 全排列算法超简单实例分析-非递归
- xilinx和altera 资源对比
- linux chmod和fchmod设置 文件和目录权限设置