Database Star: Home

SQL Decimal: Guide and Examples

Oct 6, 2022 · 5 min read ·

The SQL DECIMAL data type is useful for storing numbers with decimal places. Learn all about it, including which databases support it, and how to work with it, in this guide.

How to Use Multiple Inner Joins in SQL

Oct 4, 2022 · 8 min read ·

Share on:

In this guide, you'll learn how to use multiple inner joins in SQL, why you may want to do this, and see some examples.

How to Create a Database in MySQL

Oct 3, 2022 · 5 min read ·

Share on:

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. MySQL Create Database Command To create a new database in MySQL, you can use the CREATE DATABASE command. The simple version looks like …

How to Split a String in SQL: Guide & Examples

Oct 3, 2022 · 11 min read ·

Share on:

To split a string in SQL you can use a built-in function. The exact function depends on which database you're using.

How to Install Postgres on Mac

Oct 1, 2022 · 6 min read ·

Share on:

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

Sep 30, 2022 · 9 min read ·

Share on:

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.