int update(array $values) Update a record in the database. Parameters array $values Return Value int

Builder|Builder unionAll(Builder|Closure $query) Add a union all statement to the query. Parameters Builder|Closure $query Return Value Builder|Builder

Builder|Builder union(Builder|Closure $query, bool $all = false) Add a union statement to the query. Parameters Builder|Closure $query bool $all Return Value Builder|Builder

void truncate() Run a truncate statement on the table. Return Value void

string toSql() Get the SQL representation of the query. Return Value string

Builder|Builder take(int $value) Alias to set the "limit" value of the query. Parameters int $value Return Value Builder|Builder

mixed sum(string $column) Retrieve the sum of the values of a given column. Parameters string $column Return Value mixed

Builder|Builder skip(int $value) Alias to set the "offset" value of the query. Parameters int $value Return Value Builder|Builder

Paginator simplePaginate(int $perPage = 15, array $columns = array('*'), string $pageName = 'page', int|null $page = null) Get a paginator only supporting simple next and previous links. This is more efficient on larger data-sets, etc. Parameters int $perPage array $columns string $pageName int|null $page Return Value Paginator

Builder sharedLock() Share lock the selected rows in the table. Return Value Builder