MySQLQueryBuilder
class MySQLQueryBuilder extends DBQueryBuilder
Builds a SQL query string from a SQLExpression object
Constants
| MAX_ROWS |
Max number of rows allowed in MySQL |
Methods
Return the DELETE clause ready for inserting into a query.
Return the UPDATE clause ready for inserting into a query.
Return the FROM clause ready for inserting into a query.
Returns the WHERE clauses ready for inserting into a query.
Returns the ORDER BY clauses ready for inserting into a query.
Returns the GROUP BY clauses ready for inserting into a query.
Returns the HAVING clauses ready for inserting into a query.
Return the LIMIT clause ready for inserting into a query.
Details
in DBQueryBuilder at line 24
string
getSeparator()
Determines the line separator to use.
in DBQueryBuilder at line 36
string
buildSQL(SQLExpression $query, array $parameters)
Builds a sql query with the specified connection
in DBQueryBuilder at line 195
string
buildDeleteFragment(SQLDelete $query, array $parameters)
Return the DELETE clause ready for inserting into a query.
in DBQueryBuilder at line 215
string
buildUpdateFragment(SQLUpdate $query, array $parameters)
Return the UPDATE clause ready for inserting into a query.
in DBQueryBuilder at line 242
string
buildFromFragment(SQLConditionalExpression $query, array $parameters)
Return the FROM clause ready for inserting into a query.
in DBQueryBuilder at line 257
string
buildWhereFragment(SQLConditionalExpression $query, array $parameters)
Returns the WHERE clauses ready for inserting into a query.
in DBQueryBuilder at line 279
string
buildOrderByFragment(SQLSelect $query, array $parameters)
Returns the ORDER BY clauses ready for inserting into a query.
in DBQueryBuilder at line 303
string
buildGroupByFragment(SQLSelect $query, array $parameters)
Returns the GROUP BY clauses ready for inserting into a query.
in DBQueryBuilder at line 321
string
buildHavingFragment(SQLSelect $query, array $parameters)
Returns the HAVING clauses ready for inserting into a query.
at line 27
string
buildLimitFragment(SQLSelect $query, array $parameters)
Return the LIMIT clause ready for inserting into a query.