lampstax Posted January 21, 2009 Share Posted January 21, 2009 Hey guys, I just blew an interview because of a question: "Please name some quirks specific to MySQL. What problem would they potentially cause and how you would prevent them?" Needless to say, my idiotic stumbling response costed me the interview. So hopefully we can get a list of quirky wierd MySQL behaviors to help other future interviewees or just save someone alot of time and headaches. This post is mainly for MySQL gods to chime in while us mortal worship and learn. LOL. So please, if you know of quirky complex join behavior specific to MySQL and not other dbs, post them up, but please no question if you just want to ask how to do LEFT JOIN on two tables (unless there's quirkyness to your query!). Link to comment https://forums.phpfreaks.com/topic/141811-solved-mysql-quirks/ Share on other sites More sharing options...
Mchl Posted January 21, 2009 Share Posted January 21, 2009 If by "quirks" they mean differences from standard SQL, they're all listed in manual (accessible to mortals as well as gods) http://dev.mysql.com/doc/refman/5.1/en/compatibility.html Link to comment https://forums.phpfreaks.com/topic/141811-solved-mysql-quirks/#findComment-742452 Share on other sites More sharing options...
lampstax Posted January 21, 2009 Author Share Posted January 21, 2009 Hmm .. very likely thats what they meant. I was thinking along the line of buggy MySQL only issues, random made up example of a quirk would be something like: MAX() returns all rows when used in a complex joined with 2 LEFT JOIN and 3 RIGHT JOIN and 1 UPSIDE DOWN JOIN Link to comment https://forums.phpfreaks.com/topic/141811-solved-mysql-quirks/#findComment-742516 Share on other sites More sharing options...
Mchl Posted January 21, 2009 Share Posted January 21, 2009 I doubt they're asking about bugs, because as far as I know, none of known bugs at this time cause incorrect data to be selected. And besides, bug list changes from version to version, and they can't expect you to know all of them. Another thing that might be interesting is what limits MySQL databases http://dev.mysql.com/doc/refman/5.1/en/restrictions.html Link to comment https://forums.phpfreaks.com/topic/141811-solved-mysql-quirks/#findComment-742533 Share on other sites More sharing options...
lampstax Posted January 21, 2009 Author Share Posted January 21, 2009 Very very cool link Mchl. Thanks! Link to comment https://forums.phpfreaks.com/topic/141811-solved-mysql-quirks/#findComment-742552 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.