• 13igTyme@lemmy.world
    link
    fedilink
    English
    arrow-up
    7
    ·
    7 days ago

    I see for past experience you put :

    CREATE TABLE Resume (
        Field VARCHAR(255) PRIMARY KEY,
        Value VARCHAR(255)
    );
    
    INSERT INTO Resume (Field, Value) VALUES
    ('Experience_1_Title', ''),
    ('Experience_1_Company', ''),
    ('Experience_1_Years', ''),
    ('Experience_1_Description', '.'),
    ('Experience_2_Title', ''),
    ('Experience_2_Company', ''),
    ('Experience_2_Years', ''),
    ('Experience_2_Description', '.'),
    ('Skills_1', ''),
    ('Skills_2', ''),
    ('Skills_3', ''),
    ('Skills_4', ''),
    ('Education_Degree', ''),
    ('Education_Years', '),
    ('References', '');
    
    SELECT Field, Value FROM Resume;
    
    -- Bonus Query: Show my most "impressive" skill
    SELECT Value FROM Resume WHERE Field = 'Skills_1';
    
    -- Another Bonus: My career trajectory
    SELECT Field, Value FROM Resume WHERE Field LIKE 'Experience%';`___`