A while ago it was “Kris is on a MySQL blogging spree” day (:
Posted by jpluimers on 2023/11/07
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…WHEREand you get theANDin 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
The Wiert Corner - irregular stream of stuff 
Leave a comment