<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Joe Celko
»
Stairway to SQL Dialects Level 3: MySQL
Stairway to SQL Dialects Level 3: MySQL
Rate Topic
Display Mode
Topic Options
Author
Message
CELKO
CELKO
Posted Thursday, May 10, 2012 8:43 AM
SSCommitted
Group: General Forum Members
Last Login: Tuesday, January 15, 2013 11:11 AM
Points: 1,945,
Visits: 2,782
Comments posted to this topic are about the item
Stairway to SQL Dialects Level 3: MySQL
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
Post #1297932
Thomas-282729
Thomas-282729
Posted Saturday, June 16, 2012 1:05 PM
SSC Journeyman
Group: General Forum Members
Last Login: Tuesday, April 09, 2013 9:19 AM
Points: 89,
Visits: 469
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
Post #1317000
P Jones
P Jones
Posted Wednesday, December 05, 2012 1:28 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Yesterday @ 1:58 AM
Points: 513,
Visits: 1,014
Thanks for this useful article from one of those who earn with SQL Server but dabble with MySQL as part of running hobby websites.
Post #1392828
archie flockhart
archie flockhart
Posted Thursday, December 06, 2012 2:49 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 5:13 AM
Points: 1,123,
Visits: 986
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 =TRUE
If the expressions are BIT data, then NOT (a=b) works as an XOR equivalent.
Post #1393387
cdonlan 18448
cdonlan 18448
Posted Thursday, December 06, 2012 8:43 AM
SSC Rookie
Group: General Forum Members
Last Login: Friday, April 19, 2013 8:44 AM
Points: 45,
Visits: 283
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.
Post #1393568
CELKO
CELKO
Posted Thursday, December 06, 2012 9:09 AM
SSCommitted
Group: General Forum Members
Last Login: Tuesday, January 15, 2013 11:11 AM
Points: 1,945,
Visits: 2,782
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.
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!
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
Post #1393594
cdonlan 18448
cdonlan 18448
Posted Thursday, December 06, 2012 9:53 AM
SSC Rookie
Group: General Forum Members
Last Login: Friday, April 19, 2013 8:44 AM
Points: 45,
Visits: 283
Fair enough. As always, it was educational. Thanks!
Post #1393625
archie flockhart
archie flockhart
Posted Thursday, December 06, 2012 9:54 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 5:13 AM
Points: 1,123,
Visits: 986
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"
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.
Post #1393626
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
