laravel migration add foreign key to existing table
laravel migration add foreign key to existing table
In this session, we’ll try our hand at solving the "laravel migration add foreign key to existing table" puzzle by using the computer language.
You can add a foreign key to the existing table in laravel using migration. Laravel provides migration column type foreginId() which helps you to create a foreign key in an already existing table in your database.-
Create foreign key to an existing table in laravel 8
//Create migration file php artisan make:migration add_user_id_to_posts_table --table=posts //Create table structure using column type in the generated migration file //database\migrations\<2021_07_26_032616>_add_user_id_to_posts_table.php public function up() { Schema::table('posts', function (Blueprint $table) { $table->foreignId('user_id')->constrained(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::table('posts', function (Blueprint $table) { $table->dropForeign(['user_id']); }); } //Run artisan command to create a foreign key php artisan migrate
Laravel 8 has a foreignId() column type in migration schema builder. Which is used to create a foreign key in laravel with an UNSIGNED BIGINT equivalent column.
Related Queries
If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.
Don't forget to share this article! Help us spread the word by clicking the share button below.
We appreciate your support and are committed to providing you valuable and informative content.
We are thankful for your never ending support.
Random Code Snippet Queries: Laravel
- Laravel hasmany select not working
- 419 page expired error in Laravel
- How to add a key value pair to existing array in laravel
- Input file with max size validation in laravel
- Best Practices for Error Handling in Production Server Code (example code)
- How to upload multiple images after preview in laravel using cropper js
- How to display validation error in laravel
- SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint
- Validation errors for multiple forms on same page Laravel
- Seed database using SQL file in Laravel
- Insert dummy data in users table Laravel
- Insert Comma Separated Values in laravel
- How to pass query string to url in laravel
- Fatal error: Uncaught Error: Class "Illuminate\Foundation\Application" not found
- How to upload files to amazon s3 bucket using Laravel
- Get laravel version
- How to display pivot table column value in laravel
- How to Access Array in blade laravel
- How to create new user without form submission in laravel
- How to return a column with different name in Laravel
- Calculate age from date of birth in Laravel
- Laravel 10 starter app using breeze on live server
- Use withCount() to get total number of records with relationship
- How to get all route list
- Post model with title and body in laravel 8