Question 20702 in Mysql Question posted in
The official MySQL documentation can be found here.

How can i add new colum in existing table as a foreign in laravel 9 – Mysql

I was trying to add a new column as a foriegn key in existing table in laravel 9. But, it continuously giving SQL error. I want to create a simple category_id as a foreign_key in brand table.

The below code doesn’t work,

$table->integer('category_id')->unsigned()->nullable()->after('password');
            $table->foreign('category_id')->references('id')->on('categories')->onDelete('SET NULL');
Tags:

2

Answers


  1. 0

    Your category_id must be of big integer type
    or
    create user column like this

    $table->unsignedBigInteger('device_id')->index()->nullable();

    and
    if your table exist create new migration class and alter table to add new column in your table

    Login or Signup to reply.
  2. 0

    try:

    $table->foreignId('category_id')->after('password');
$table->foreign('category_id')->references('id')->on('categories')->onDelete('SET NULL');

    See more about DB Column Types.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search