RyanGoh's Eportfolio

4. Inserting new column

Inserting a new column to the existing table Part 1

DROP TABLE IF EXISTS inventory;

CREATE table inventory (

Inventory_ID INTEGER UNIQUE NOT NULL,

Inventory_Item_Name NOT NULL,

Inventory_Desc TEXT DEFAULT "Refers to Inventory_Item_Name"

);

INSERT INTO inventory (Inventory_ID, Inventory_Item_Name) VALUES ("001", "MacBook");

INSERT INTO inventory (Inventory_ID, Inventory_Item_Name) VALUES ("002", "MacBook Pro");

SELECT * FROM inventory;

ALTER table inventory ADD Inventory_Price INTEGER;

Inserting a new column to the existing table with "Default" constraint

DROP TABLE IF EXISTS inventory;

CREATE table inventory (

Inventory_ID INTEGER UNIQUE NOT NULL,

Inventory_Item_Name NOT NULL,

Inventory_Desc TEXT DEFAULT "Refers to Inventory_Item_Name"

);

INSERT INTO inventory (Inventory_ID, Inventory_Item_Name) VALUES ("001", "MacBook");

INSERT INTO inventory (Inventory_ID, Inventory_Item_Name) VALUES ("002", "MacBook Pro");

SELECT * FROM inventory;

ALTER table inventory ADD Inventory_Price INTEGER DEFAULT "$1000";

Google Sites

Report abuse