Original post: aus.social (Mastodon)

you are viewing a single comment's thread
view the rest of the comments
[–] 7 points 1 year 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%';`___`
  • source
  • parent