تحديد قيمة افتراضية باستخدام DEFAULT

-- Create The Table
CREATE TABLE offers (
    name TEXT,
    discount INTEGER DEFAULT 10
);

-- Insert Data Without A Discount
INSERT INTO offers (name)
VALUES ('Welcome Offer');

-- Display Data
SELECT name, discount
FROM offers;

name | discount
Welcome Offer | 10

-- Insert Data With A Discount
INSERT INTO offers (name, discount)
VALUES ('Summer Offer', 20);

-- Display Data
SELECT name, discount
FROM offers;

name | discount
Welcome Offer | 10
Summer Offer | 20