python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - alter-table

Unable to alter table in using route in Laravel 8

I have a migration in Laravel 8 and already migrate. I was trying to alter the table and make nullable to one of the fields on that table. I have run the following command composer require doctrin...
test-img

Glen D P Maramis

laravel-8

alter-table

laravel-migrations

Votes: 0

Answers: 1

Latest Answer

You are not importing the Blueprint class. Add the following import to your file that's using Schema::table() use Illuminate\Database\Schema\Blueprint;
test-img

Elias Soares

SQL - Insert an ID column in a certain order & return matched values

I am hoping to alter a table from Sorting the table by two columns, and adding a sequential ID column, one starting from 0, the other from 1 With the aim of being able to match the ID0 and ID1 colum...
test-img

JarradH

sql

indexing

sql-order-by

alter-table

Votes: 0

Answers: 0

ADD COLUMN with CONSTRAINT

I have a table name Stu_d. In this, I have created 3 columns {Stu_id INT PRIMARY KEY, Name VARCHAR(20), Roll_no INT(5)}. I need to add 1 more column with the name of Mobile_no with INT data type and h...
test-img

Vasu Gupta

mysql

primary-key

rdbms

alter-table

unique-key

Votes: 0

Answers: 1

Latest Answer

The syntax for this is ALTER TABLE Stu_d ADD COLUMN Mobile_no INT(10) UNIQUE ; if you want to name the constraint then use ALTER TABLE Stu_d ADD COLUMN Mobile_no INT(10) ; ALTER TABLE Stu_d ADD CONST...
test-img

user18098820

Alter large table on Aurora Serverless MySQL

We use AWS Aurora Serverless MySQL v2.07.1. We would like to alter one of our table and add a column to this table. The issue is that the table contains more than 500 Millions rows, which gives us a t...
test-img

Latnac

alter-table

aws-aurora-serverless

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs