Content Of Laravel Database: Query Builder

  • Introduction
  • Retrieving Results
  • Retrieving All Rows From A Table
  • Retrieving A Single Row / Column From A Table
  • Retrieving A List Of Column Values
  • Chunking Results
  • Aggregates
  • Selects
    1. Raw Expressions
  • Joins
    1. Inner Join Clause
    2. Left Join Clause
    3. Cross Join Clause
    4. Advanced Join Clauses
    5. Sub-Query Joins
  • Unions
  • Where Clauses
  • Simple Where Clauses
  • Or Statements
    1. Additional Where Clauses
    2. whereBetween
    3. whereNotBetween
    4. whereIn / whereNotIn
    5. whereNull / whereNotNull
    6. whereDate / whereMonth / whereDay / whereYear / whereTime
    7. whereColumn
  • Parameter Grouping
  • Where Exists Clauses
  • JSON Where Clauses
  • Ordering, Grouping, Limit, & Offset
  • orderBy
  • latest / oldest
  • inRandomOrder
  • groupBy / having
  • skip / take
  • Conditional Clauses
  • Inserts
  • Auto-Incrementing IDs
  • Updates
    1. Updating JSON Columns
    2. Increment & Decrement
  • Deletes

Pessimistic Locking

News Reporter
IT Software and web development, Core PHP, JavaScript, JQuery, HTML, CSS, CakePHP, Angularjs, Codeigniter etc.

Leave a Reply

Your email address will not be published. Required fields are marked *

error: