Category: Database

When working with large datasets it is useful to have a way to insert multiple records into a database at once. Laravel Eloquent allows a simple way to bulk insert by using the insert method. To...

In this tutorial, I'll guide you through the process of changing a table column to nullable in Laravel with sample code and step-by-step instructions.

In this guide, I'll walk you through the steps to change a column type of a column, from varchar(255) to text, increasing its max length to 65,535 characters.

In this tutorial I'll show you how to add a new column after an existing one. By following the steps you'll be able to control the order of your table columns.

Laravel allows chaining calls to where() and orWhere() methods to add multiple conditions. In this post you'll lean how to use them and more advanced cases.

In this guide you'll learn to print raw SQL generated by Laravel Query Builder or Eloquent. Also you'll learn to enable a Query log to capture multiple queries.