• 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%';`___`