|
| | sql ($columns='', $tables='', $where='', $orderBy='', $groupBy='', $having='') |
| |
| | __construct ($columns='', $tables='', $where='', $orderBy='', $groupBy='', $having='') |
| |
| | sql ($columns='', $tables='', $where='', $orderBy='', $groupBy='', $having='') |
| |
| | __construct ($columns='', $tables='', $where='', $orderBy='', $groupBy='', $having='') |
| |
| | __construct ($columns='', $tables='', $where='', $orderBy='', $groupBy='', $having='', $forUpdate=false) |
| |
| | setDb ($db) |
| |
| | setColumns ($string, $distinct=false) |
| |
| | setTables ($string) |
| |
| | setGroupBy ($string) |
| |
| | setOrderBy ($string) |
| |
| | setWhere ($string) |
| |
| | setWhereAnd ($string) |
| |
| | setWhereOr ($string) |
| |
| | setHaving ($string) |
| |
| | setHavingAnd ($string) |
| |
| | setHavingOr ($string) |
| |
| | setJoin ($table1, $table2, $cond, $type='INNER') |
| |
| | setLeftJoin ($table1, $table2, $cond) |
| |
| | setRightJoin ($table1, $table2, $cond) |
| |
| | setForUpdate ($forUpdate=false) |
| |
| | SetSetOperation ($operation, MSQL $sql) |
| |
| | bind ($parameters=null) |
| |
| | prepare ($parameters=null) |
| |
| | insert ($parameters=null) |
| |
| | insertFrom ($sql) |
| |
| | delete ($parameters=null) |
| |
| | update ($parameters=null) |
| |
| | select ($parameters=null) |
| |
| | clear () |
| |
| | setParameters () |
| |
| | addParameter ($value) |
| |
| | setRange () |
| |
| | setOffset ($offset, $rows) |
| |
| | findStr ($target, $source) |
| |
| | parseSqlCommand (&$cmd, $clause, $delimiters) |
| |
| | createFrom ($sqltext) |
| |