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.
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.
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.
If you want to install a PostgreSQL database on macOS, you can follow the steps in this guide.
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.
Get a reference for many of the common SQL commands and features on this SQL Cheat Sheet page.
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.
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.
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.
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 ยป
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.