5 ms·
SELECT * FROM Children WHERE naughty=false;
by julianozen 11y ago
SELECT * FROM Children WHERE naughty=false;
- whoopdedo 11y agoLittle Bobby Tables isn't getting anything for Christmas this year. Or everything, I guess it depends on how the implementation handles failure conditions.
- anemic 11y agoas you seem to have some inside information can you share some details about the database schema: is naughty field not null or nullable? what about indexing a table on a boolean column?
- logfromblammo 11y agoNiceness is an ENUM 'not known', 'nice', 'naughty', 'nasty' Additionally, the nice list is a bitemporal table, and CheckStatus is also an ENUM ( 'nunce', 'once', 'twice', 'more' ). Foreign keys go to the Person and Elf tables.
- logfromblammo 11y agoNice try, but everyone knows that Santa keeps his database in 6NF.
- Symbiote 11y agoHe's making a database He's sorting it twice SELECT * from contacts WHERE behavior = 'nice' SQL Clause is coming to town (Saw it on Facebook, I don't know the source.)
- hackmiester 11y agoHere is the source: https://twitter.com/KarenMN/status/677111492135661569 https://twitter.com/KarenMN/status/677111492135661569