Database Star: Home

A Beginner's Guide to an SQL Cursor (In Many Databases)

Jul 6, 2020 · 21 min read ·

Share on:

Learn what SQL cursors are and how to use them.

SQL INT Data Types in Different Databases

Jul 4, 2020 · 5 min read ·

Share on:

In this guide, you'll see all of these INT data types, see their restrictions, and how they compare between databases.

SQL Server CHARINDEX Function Guide with Examples

Jul 4, 2020 · 4 min read ·

Share on:

Learn how to use the CHARINDEX function.

How to Convert DATETIME to DATE in SQL Server

Jul 2, 2020 · 5 min read ·

Share on:

Learn how to convert a DATETIME to DATE in SQL Server.

How to Resolve Column count doesn't match value count at row 1

Jul 2, 2020 · 4 min read ·

Share on:

Learn how to resolve this "Column count doesn't match value count" error

How to Fix The "Every derived table must have its own alias" Error in MySQL

Jun 28, 2020 · 4 min read ·

Share on:

Learn how to resolve this error.

How to Start MySQL Server on Mac, Windows, and Linux

Jun 28, 2020 · 3 min read ·

Share on:

Do you want to know how to start, stop, and restart the MySQL server? Learn how you can do that on each operating system in this article.

SQL vs MySQL vs SQL Server: What's the Difference?

Jun 27, 2020 · 4 min read ·

Share on:

Learn the difference between SQL and MySQL.

How to Install Oracle on a Mac (2020)

May 10, 2020 · 11 min read · sql ·

Share on:

In this post, you're going to learn the exact steps to take to install Oracle on your Mac computer.

SQL CAST Function Explained with Examples

Apr 30, 2020 · 7 min read · sql-functions ·

Share on:

The SQL CAST function is quite powerful, but it can be hard to use. Learn how to use it and what it can do in this article.