• 13igTyme@lemmy.world
        link
        fedilink
        English
        arrow-up
        7
        ·
        5 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%';`___`