SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Joe Celko / Stairway to SQL Dialects Level 3: MySQL / Latest Posts

RE: Stairway to SQL Dialects Level 3: MySQL

archie flockhart — Thu, 06 Dec 2012 09:54:31 GMT

[quote]When I was on ANSI X3H2, we spent a few days on this topic. The ruels aer:1) If it is an ISO Standard, you spell it out. Hence "S-Q-L" is the right way. However, the french will insist that the letters are in the french order. Hence "UTC" and not "Universal Coordinated Time" [/quote]It's worse than that: the correct French order would be "TUC". "UTC" is a committee-driven compromise which is neither good English nor good French. I'm not sure that it is officially an abbreviation of anything at all.

RE: Stairway to SQL Dialects Level 3: MySQL

cdonlan 18448 — Thu, 06 Dec 2012 09:53:05 GMT

Fair enough. As always, it was educational. Thanks!

RE: Stairway to SQL Dialects Level 3: MySQL

CELKO — Thu, 06 Dec 2012 09:09:50 GMT

[quote] who cares how it's pronounced? Do we need an IEEE rule for this too? Please enlighten me if you really think this is even worth our time discussing and why.[/quote] Because when I worked for them doing a series of webcasts on basic RDBMS, etc their people were constantly catching me for using "My Sequel" and not "MY S-Q-L" in my recordings. Do a dozen re-takes and you remember. When I was on ANSI X3H2, we spent a few days on this topic. The ruels aer:1) If it is an ISO Standard, you spell it out. Hence "S-Q-L" is the right way. However, the french will insist that the letters are in the french order. Hence "UTC" and not "Universal Coordinated Time" 2) if it is a US Federal Standard, you prounounce it. This is why a "Physicians Standards Review Organization" is a "piss row"; honest!

RE: Stairway to SQL Dialects Level 3: MySQL

cdonlan 18448 — Thu, 06 Dec 2012 08:43:17 GMT

Joe, as usual, your content is brilliant, but please indulge me in a minor quibble that I found really annoying right out of the gate with this article and that was regarding the pronunciation of MySQL. I seem to recall even my database textbook in college (25 years ago) mentioning that the S-Q-L or 'sequel' pronunciations are mere conventions. My point : who cares how it's pronounced? Do we need an IEEE rule for this too? Please enlighten me if you really think this is even worth our time discussing and why.Sincerely,A big fan.

RE: Stairway to SQL Dialects Level 3: MySQL

archie flockhart — Thu, 06 Dec 2012 02:49:18 GMT

XOR isn't equivalent to NOT (NOT a AND NOT b).If a=TRUE and b=TRUE, then XOR(a,b) =FALSE but the expression above =TRUEIf the expressions are BIT data, then NOT (a=b) works as an XOR equivalent.

RE: Stairway to SQL Dialects Level 3: MySQL

P Jones — Wed, 05 Dec 2012 01:28:14 GMT

Thanks for this useful article from one of those who earn with SQL Server but dabble with MySQL as part of running hobby websites.

RE: Stairway to SQL Dialects Level 3: MySQL

Thomas-282729 — Sat, 16 Jun 2012 13:05:06 GMT

You missed one of the biggest joyful "features" of MySQL: check constraints are parsed but ignored."The CHECK clause is parsed but ignored by all storage engines. See Section 1.8.5.4, “Foreign Key Differences”. http://dev.mysql.com/doc/refman/5.6/en/create-table.html

Stairway to SQL Dialects Level 3: MySQL

CELKO — Thu, 10 May 2012 08:43:39 GMT

Comments posted to this topic are about the item [B]Stairway to SQL Dialects Level 3: MySQL[/B]