Cursors are a feature in many SQL databases that allow you to work with data.
They exist in SQL Server, Oracle, MySQL, PostgreSQL, and likely many other databases.
But what are they and how do you use them?
Let’s learn all about them in this guide.
INT is short for integer, and is a group of data types in many databases that store numbers. There are many INT data types in the major SQL databases.
In this guide, you’ll see all of these INT data types, see their restrictions, and how they compare between databases.
Let’s take a look.
Are you looking to find a string within another string in SQL Server? You can do that with the CHARINDEX function, which is SQL Server’s version of an INSTR function.
Learn how to use the function and see some examples in this article.
What is a clustered index? What is a non-clustered index? And how are they different?
They are two types of indexes in SQL Server.
Learn what they are and see some examples in this guide.
Do you have a DATETIME value in SQL Server that you want to convert to a DATE, or only get the DATE component?
You can do that in SQL Server. There are several ways to do it. I’ll show you how in this article.
Are you getting the error “Column count doesn’t match value count at row 1” in MySQL?
In this article, I’ll show you how to resolve this error, as well as what it means, and some examples.
Let’s take a look.
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.
Are you writing a query in MySQL and getting an error of “1248: Every derived table must have its own alias”? If so, it’s a simple error to fix.
If you’re learning software development you might have heard of the terms SQL and MySQL. And you might be wondering, what’s the difference? Also, what does SQL Server mean and is it the same thing?