13:34 09-08-2023

use assignment;
CREATE TABLE countries (
    country_name VARCHAR(50),
    population INT,
    capital VARCHAR(50)
);
INSERT INTO countries (country_name, population, capital)
VALUES 
('China', 1382, 'Beijing'),
('India', 1326, 'Delhi'),
    ('United States', 324, 'Washington D.C.'),
    ('Indonesia', 260, 'Jakarta'),
    ('Brazil', 209, 'Brasilia'),
    ('Pakistan', 193, 'Islamabad'),
    ('Nigeria', 187, 'Abuja'),
    ('Bangladesh', 163, 'Dhaka'),
    ('Russia', 143, 'Moscow'),
    ('Mexico', 128, 'Mexico City'),
    ('Japan', 126, 'Tokyo'),
    ('Philippines', 102, 'Manila'),
    ('Ethiopia', 101, 'Addis Ababa'),
    ('Vietnam', 94, 'Hanoi'),
    ('Egypt', 93, 'Cairo'),
    ('Germany', 81, 'Berlin'),
    ('Iran', 80, 'Tehran'),
    ('Turkey', 79, 'Ankara'),
    ('Congo', 79, 'Kinshasa'),
    ('France', 64, 'Paris'),
    ('United Kingdom', 65, 'London'),
    ('Italy', 60, 'Rome'),
    ('South Africa', 55, 'Pretoria'),
    ('Myanmar', 54, 'Naypyidaw');
    insert into countries (country_name, population, capital)
VALUES
    ('Canada', 38, 'Ottawa'),
    ('Australia', 25, 'Canberra');
    
    set sql_safe_updates = 0;
    
    update countries
    set capital = 'new delhi'
    where capital = 'delhi';
    
    set sql_safe_updates = 1;
    
ALTER TABLE countries
RENAME TO big_countries;