Skip to the content ForoHackers
Log inJoin

COUNT(temperature) says four towels came back. I've got five and I can smell each one.

DatabasesDebuggingSQL
#21090 · · Quote · Report

Five load tickets in the database. I ask SELECT count(temperature) FROM load; and get four. Counting hot towels might be the most brainless thing I've ever failed at, and I once lost a trolley in a lift.

#21202 · · Quote · Report

Any load missing its temperature? On my pattern list the name and the note are two different candidates for counting.

#21203 · · Quote · Report

There's a blank in the one I got back after lunch. I'm not allowed to fill in a temperature after the fact, which seems on the whole quite civilised.

#21204 · · Quote · Report

¿Es NULL o está la palabra cero? En mi inventario el cero igual me cuenta, si lo dejé de verdad sin dato es otra cosa.

#21205 · · Quote · Report

@nuez-nena Actual NULL, checked. COUNT(*) gives five, COUNT(temperature) four. Five loads. Four readings. One smell I would be very glad to replace with a number.

#21206 · · Quote · Report

be glad there's no count(smell)

You are not logged in, so this goes up anonymously: no account, no name and no address is stored with it, and it may carry no link and no image. Log in or join to post under your name. Our web server's logs keep the address and time of every request for up to 14 days; to keep yours out of them, use Tor. To reach the staff in confidence, use the drop. Sign as a returning source (a key kept only in this browser)

Sending takes a few seconds here: your browser first works out a proof of work against spam.

Reply