Little Timmy Tables

andioop@programming.dev · 15 days ago

Little Timmy Tables

NullPointerException@lemmy.ca · 15 days ago

Why would Santa need two separate tables for this?

unalivejoy@lemmy.zip · 15 days ago

I would make two separate views.

CREATE VIEW NiceList AS
 SELECT * FROM Children
  WHERE behavior = 'nice' 
   AND parent.income > 40000; 
CREATE VIEW NaughtyList AS
 SELECT * FROM Children
  WHERE behavior = 'naughty';

KairuByte@lemmy.dbzer0.com · 15 days ago

Why are we using magic strings for behavior?

unalivejoy@lemmy.zip · 15 days ago

Feel free to fork my comment.

branch@lemmy.world · 1 day ago

CREATE VIEW NiceList AS
 SELECT * FROM Children
  WHERE behavior > 2000
   AND parent.income > 40000; 
CREATE VIEW NaughtyList AS
 SELECT * FROM Children
  WHERE behavior <= 2000;