From quite a while ago, and still interesting:
- Via [Wayback/Archive] Kris on Twitter: “… In which we show a weird SQL error message, and what really was wrong.”:
[Wayback/Archive] Truncated incorrect DOUBLE value | Die wunderbare Welt von Isotopp which is actually a correct but confusing error when performing a
SET
…WHERE
and you get theAND
in the wrong place. - [Wayback/Archive] Kris on Twitter: “… In which we try to access the (possibly generated) raw SQL sent to the database, even in the face of Syntax error, using Python.”
[Wayback/Archive] Debugging SQL in Python | Die wunderbare Welt von Isotopp on being “able to see the actual SQL string that has been sent to the database in order to facilitate interactive debugging” for mysqlclient and the the official MySQL 8 Connector/Python package.
Why are these interesting?
For me it is because tiny hick-ups can be just as hard for senior people as for novices.
–jeroen