Never Forget An SQL Symbol With This Comprehensive Cheat Sheet

If you can’t remember what every single symbol and operator does in SQL, don’t worry — most of us can’t either. That’s what cheat sheets are for and Periscope Data has just the thing for the average database developer.

Image: Visual Pharma

As the Periscope Data post itself mentions, searching the web for operators can be difficult, as they’re usually eaten by the engine’s input sanitisation, resulting incorrect results (or none at all). So instead of hitting up Google, try PD instead.

The cheat sheet starts with the basics — equality, addition, subtraction, multiplication and so on — before descending into the more complex. It doesn’t delve into regular expression, a massive topic in itself, but it does go over SQL’s own string operators, such as concatenation and character matching.

It also covers symbols used in SQL expressions, including type conversion, joins and for Postgres, JSON operators.

If SQL sees constant attention from your keyboard, it a good page to bookmark.

SQL Symbol Cheat Sheet [Periscope Data]

The Cheapest NBN 50 Plans

Here are the cheapest plans available for Australia’s most popular NBN speed tier.

At Lifehacker, we independently select and write about stuff we love and think you'll like too. We have affiliate and advertising partnerships, which means we may collect a share of sales or other compensation from the links on this page. BTW – prices are accurate and items in stock at the time of posting.