I use MySQL at work, and MySQL doesn’t support the || operator for string concatenation.
So, in the book, an expression like:
evaluates to ItemOneItemTwo
In MySQL, || is a logical operator, just like in Ruby, so to get the above evaluation, you’d need to use:
That would give you ItemOneItemTwo. Of course, string concatenation pairs well with spaces between the strings you’re trying to concatenate, so please know that the CONCAT function can take any number of arguments, for example:
I started this whole thing in 2012, but didn’t do any sort of review for 2012, 2013, or 2014. Writing that sentence confirms the value of this review - I wish I had done a review those years, if for no other reason than to remind future Josh what the heck was going on in his life then.
If you've got two hours to kill the next few days write up "What I learned in 2017 doing X" and put it somewhere where people can read it. (Ideally publicly, but I understand that doesn't work for everyone / every job / etc.)
I suspect that “being curious” will correlate well with positive outcomes in my life, on pretty much any time horizon, be it days, weeks, or decades. Curiosity feels like a tolerable antidote to boredom, though boredom in and of itself is something to celebrate and embrace.
The goal isn’t to not be bored, it is to not be jaded and closed.
I enjoy spending time with people who are both older than me, and people who are just plain old. When they display traits or attitudes that I either want to emulate or want to avoid, I try to reverse engineer what led to that thing I do or don’t want.
The presence/absence of curiosity has correlated well the presence/absence of other traits I want to emulate.
I’ve got more time in my life now, and the company I work for makes heavy use of SQL queries, so I’m spending a little time each day working through this book. The following started as a gist, and I’m putting here, so I can more easily share it with others.
Why Study SQL
Pretty much everything on the internet lives in a database. I figure any boost to my SQL skills will provide outsized returns down the road.
For example, just today I used some basic SQL queries to validate an assumption I had about the frequencies of null values in certain places in our database. I wouldn’t have even thought to try that, if I didn’t know in advance what I could do with a basic SQL query.
If you buy this book, and want to get set up with it’s accompanying data on your own computer, so you can practice yourself and follow along with the book… read on.
The friction of getting set up kept me from getting started with this book, and I don’t want that to happen to you too. :)