How to insert a value to a column using the alter statement

Question

I have created an already existing table, but I altered it so how can I create a create a column with a value.

Answer 1

First add column then update column value

Answer 2

Patrick Noulet

There is Constraint DEFAULT also which you can set with default value while adding new column but all record will be updated with default value.

So add new column with NULL and update column value on primary id

Answer 3

Patrick Noulet

1 - When you want to update single row

UPDATE Subscription_users SET Gender = 'Male' WHERE ID = 1

2 - When you want to update all row

UPDATE Subscription_users SET Gender = 'Male'

3 - When you want to update multiple row

UPDATE Subscription_users SET Gender = 'Male' WHERE ID IN (1, 2, 3, 4)

Answer 4

UPDATE table_name SET column_name = value WHERE primaryid_value = ?

Answer 5

Patrick Noulet

Show your complete script

Answer 6

Patrick Noulet

You have to update Gender column on primary id which are 1, 2, 3, 4

I already told you update script

Answer 7

Ok, I have seen What went wrong in my code, thanks A͢J

Answer 8

Thanks A͢J but If you don't mind can you show me how I can insert values into the rows from the newly created column

Answer 9

When I was done creating the column through the alter statement, then I tried inserting values into the rows but it keeps showing null values.

Answer 10

CREATE DATABASE Sections
USE Sections
CREATE TABLE Subscription_users(
ID INT NOT NULL AUTO_INCREMENT,
FirstName VARCHAR (30) NOT NULL,
LastName VARCHAR (30) NOT NULL,
) ;
INSERT INTO Subscription_users(ID, FirstName,LastName)
VALUES (1,'Caleb','Smith'),
(2,'Anthony','Young'),
(3,'Alexander','Thomas'),
(4,'Williams','Martinelli');

Answer 11

This was the first code, then I decided to alter the table Subscription_users and included the column Gender, so how can I create a row for it, when it keeps telling me null values.

Answer 12

Could you please show me an example of the code