Today, We want to share with you Laravel MySQL Database Relationship Queries.In this post we will show you Creating Quick MySQL Relational Database, hear for Laravel MySQL Eloquent Relationships Tutorial Example From Scratch we will give you demo and example for implement.In this post, we will learn about Eloquent Laravel MySQL Relationships with an example.
Laravel MySQL Database Relationship Queries
There are the Following The simple About Laravel MySQL Database Relationship Queries Full Information With Example and source code.
As I will cover this Post with live Working example to develop Speed up relationship queries in Laravel, so the Laravel nested relationships for this example is following below.
Laravel Types of relationship in database with example
List Types of relationships supported by Laravel
There are Laravel support 7 types of table relationships
- One To One
- One To Many
- One To Many (Inverse)
- Many To Many
- Has Many Through
- Polymorphic Relations
- Many To Many Polymorphic Relations
Creating indexes in Laravel
Adding indexes to your tables in Laravel is very straightforward. In your migrations you can add:
//Laravel Single index
$table->index('video_id');
//Laravel Compound index
$table->index(['notification_type', 'notification_id']);
One to one / one to many relationships
Simple Eloquent Laravel One to One Relationship
$table->unsignedInteger('product_id');
$table->foreign('product_id')->references('id')->on('products')->onDelete('cascade');;
$table->index('product_id');
Many to many relationships
One to Many Relationship in Laravel 5.7 Eloquent
// products table
$table->increments('id');
// cats table
$table->increments('id');
// cat_product pivot table
$table->unsignedInteger('product_id');
$table->unsignedInteger('cat_id');
we can add two to our pivot table
// cat_product pivot table
$table->unsignedInteger('product_id');
$table->foreign('product_id')->references('id')->on('products')->onDelete('cascade');
$table->unsignedInteger('cat_id');
$table->foreign('cat_id')->references('id')->on('cats')->onDelete('cascade');
Laravel duplicate can never exist in your database
$table->unique(['product_id', 'cat_id']);
Polymorphic / many to many polymorphic relationships
// videos table
$table->increments('id');
// articles table
$table->increments('id');
// messages table
$table->increments('id');
$table->text('message_body');
$table->text('notification_type');
$table->unsignedInteger('notification_id');
// messages table
$table->index(['notification_id', 'notification_type']);
Angular 6 CRUD Operations Application Tutorials
Read :
Summary
You can also read about AngularJS, ASP.NET, VueJs, PHP.
I hope you get an idea about Laravel MySQL Database Relationship Queries.
I would like to have feedback on my Pakainfo.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.