How to Create a Database in MySQL
If you want to create a new database in MySQL, you can either use an SQL command or follow the steps in an IDE such as MySQL Workbench. Learn how to do it in both ways in this guide.
How to Split a String in SQL: Guide & Examples
To split a string in SQL you can use a built-in function. The exact function depends on which database you’re using. Learn all about how to split a string in this guide.
How to Install Postgres on Mac
If you want to install a PostgreSQL database on macOS, you can follow the steps in this guide.
SQL IN and SQL NOT IN – Guide & Examples
The SQL IN and SQL NOT IN keywords allow you to compare against a list of values, instead of a single value. Learn all about how to use them and see some examples in this guide.
SQL Cheat Sheet
Get a reference for many of the common SQL commands and features on this SQL Cheat Sheet page.
OTN Appreciation Day
As part of the #ThanksOTN (or ThanksODC) idea started by Tim Hall on Twitter, I’ve written about a few things I appreciate over the years. Here they are, all in one post.
MySQL Privileges The Ultimate Guide
Privileges in MySQL are an important part of the database. In this guide, you’ll learn: what privileges are and what they do the privileges that are available how to give and take privileges from individual users and groups of users how to see privileges available for a user Let’s get into it.
How to Handle Database Timezones
Working with timezones can be one of the hardest things in a database. In this guide, you’ll learn: Why timezones are hard to work with A rule that covers almost all situations An exception to this rule Let’s get into it.
A Guide to Oracle PDB (Pluggable Database) and CDB (Container Database)
If you’ve worked with Oracle databases recently, you may have heard of the terms “pluggable database” and “container database”. In this guide, you’ll learn: what these terms mean the benefits of this new architecture how to connect to a container or pluggable database how to switch between these databases how to create a container or …
A Guide to Oracle PDB (Pluggable Database) and CDB (Container Database) Read More ยป
MySQL ENUM: The Ultimate Guide
The ENUM data type in MySQL is a helpful data type for specifying a valid range of values. In this guide, you’ll learn all about the MySQL ENUM feature, including: what the ENUM feature is how to use it on your database some disadvantages of this feature Let’s get into it.