Laravel 5.* introduces a simple syntax for lookups and updates based on the value of specific keys in your JSON columns. This operation is only supported on databases that support JSON columns. When updating a JSON column, you should use…

If you want to increment or decrement opration using update() method of laravel query builder then you also do that, i am showing you how to increment and decrement value of column in table by using increment(), and decrement(). Both…

ck Shared lock is, when more than one transaction is granted read access to a given record. One transaction gets shared lock on a record. DB::table(‘tbl_order’)->where(‘amount’, ‘>’, 100)->sharedLock()->get(); lockForUpdate You can use it, when reading to prevent the rows from…

If the table has an auto-incrementing id, use the insertGetId method to insert a record and then retrieve the ID. Many time user insert one record in table and find inserted id and this id insert another table. $insert_id =…

The orderBy method is used to sort the result-set in ascending or descending order. The first argument to the orderBy method should be the column you wish to sort by, while the second argument controls the direction of the sort…

The Where clause is used to extract only those records that fulfill a specified condition. The most basic call to where requires three arguments. The first argument is the name of the column. The second argument is an operator, which…

Sometimes you need to bind multiple queries then you can use union in laravel. If you use union then laravel query builder provide union method for mysql union. When you are doing big project or ERP level project then mostly…

To perform a “cross join” use the crossJoin method with the name of the table you wish to cross join to. Cross joins generate a Cartesian product between the first table and the joined table. Let’s create a crossJoin method…

The leftJoin method has the same signature as the join method. When I fetch all columns from the get-go, the query takes too load to complete (around 5 secs on 350k rows), whereas with a left join that’s cut into…

One such cool feature us using raw queries in laravel. These expressions will be injected into the query as strings but this is really helpful when you want to use raw expressions like aggregate functions. The queries can be executed…