Escaping confusion with Python 3 + MySQL

Jussi Piitulainen jussi.piitulainen at helsinki.fi
Tue Mar 28 01:09:17 EDT 2017


Gregory Ewing writes:

> Νίκος Βέργος wrote:
>
>> Its still a mystery to em whay this fails syntactically when at the
>> same time INSERT works like that.
>
> I don't think *anyone* understands why SQL was designed with
> INSERT and UPDATE having completely different syntaxes.
> But it was, and we have to live with it.

A story I heard is that IBM had two competing teams working to design a
database system. One team understood programming languages. The other
team understood storage system layouts. The latter team won, and their
system grew up to be SQL.



More information about the Python-list mailing list