2022-10-13 04:55
In this guide, you’ll learn how to format DATE values into many different formats, how to insert DATE values into a table, and more. Summary You can insert date values into a DATE colu… Read More
Blog Directory > Software Blogs > Programming Blogs > Database Star programming Blog >
Database Star Blog
databasestar.com
Tags:
mysql
ultimate guide
formats
timezones
decimal
delete
multiple
mysql enum
oracle
mysql privileges
Practical advice for database developers.
2022-10-11 01:11
In this article, you’ll learn what the ON DELETE CASCADE keyword means and what it does. What is On Delete Cascade in SQL? The ON DELETE CASCADE is an option when defining a foreign ke… Read More
2022-10-10 02:40
In this guide, you’ll learn all about Oracle Live SQL, the web-based tool by Oracle that has a built-in Oracle database for practising your SQL. What Is Oracle Live SQL? Oracle Live SQ… Read More
2022-10-06 01:26
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. What is… Read More
2022-10-04 04:23
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. Can You Use Multiple Inner Joins in SQL? Yes, you can. Using an… Read More
2021-12-22 03:52
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 priv… Read More
2021-12-12 23:21
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 exce… Read More
2021-11-28 21:10
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 lear… Read More
2021-10-14 03:45
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 featur… Read More
2021-10-13 18:53
Do you want to change a user’s password on a MySQL database? If so, then this guide is what you need. You’ll learn: a brief summary of the command how to use the command to chang… Read More
2021-10-07 03:19
If you’re interested in the process to backup and restore a MySQL database, then mysqldump is the tool to use. In this guide, you’ll learn: what mysqldump is how to use it to bac… Read More
2021-10-04 00:49
Do you want to learn how to generate pivoted data or pivot tables in MySQL? In this article, you’ll learn: what the pivot concept is how to generate a pivot table in MySQL how to gener… Read More
2021-09-29 23:21
In this article, you’ll learn: what the PIVOT feature is in SQL Server a few examples of using PIVOT how to use the UNPIVOT feature Sometimes you’ll need to pivot your data if it… Read More
2021-09-24 03:29
If you want to set up Flyway DB on your database, you’ve come to the right place. In this guide, you’ll learn: What Flyway is A step-by-step guide to setting it up on your databa… Read More
2021-09-21 21:27
Do you want to, or need to, learn how to use GitHub for your SQL files? GitHub is a commonly-used service for application development. But it can also be used for your SQL scripts and other… Read More
2021-09-20 01:02
If you’re working with PL/SQL code and processing multiple rows, there are two techniques you can use to improve the performance of your code. These techniques are BULK COLLECT and FOR… Read More
2021-09-15 22:23
If you’re using SQL Developer, there may be a time where you want to import a CSV file into your Oracle database. SQL Developer includes a wizard that lets you import a file. Let&rsquo&hell…Read More
2021-09-15 04:26
Are you using MySQL Workbench and want to export your database? Or do you have an export file and want to import your database? In this guide, you’ll learn how to export a database and… Read More
2021-09-13 03:36
In SQL, you may need to find out more about the table and its columns. This is often called “sql describe table” or describing a table. Different vendors (Oracle, SQL Server, MyS… Read More
2021-09-11 18:21
Have you ever needed to calculate a “running total” or “cumulative sum” in SQL? You can do this in SQL without any other programming language to process the data. In… Read More
2021-09-09 00:15
Oracle databases come with a couple of built-in users: SYS and SYSTEM. These are administrative-level users and are quite powerful. You’ll probably want to create your own users so you… Read More
2021-09-05 19:43
In this guide, you’ll learn: What Docker is (briefly) Why you might want to use it for your database How to set it up How to get a database (Oracle, SQL Server, MySQL, or PostgreSQL) r… Read More
2021-07-14 04:11
If you want to see how to write a complex query on an SQL database, this example will show you Read More
2021-06-29 06:56
In this post, you'll learn how to set up a sample database so you can practice your SQL queries. This database works on Oracle, SQL Server, MySQL, and PostgreSQL Read More
2021-06-22 20:41
As a software developer you'll use a range of tools to do your job. Here's a list of software development tools you may consider using Read More
2021-06-15 21:13
Using Docker for an SQL Server database is one way to run the database. Learn how to set up an SQL Server Docker instance in this guide Read More
2021-06-15 06:11
Docker can be used to run an Oracle database, which is a good way to run Oracle on a Mac or as an alternative on Windows. Learn how to set it up in this guide Read More
2021-06-13 20:46
The SQL DEFAULT constraint is something that can be added to tables to specify a default value for a column Read More
2021-06-09 21:04
The Access denied for user 'root'@'localhost' error is common in MySQL. Learn what it means and how to resolve it in this article Read More
2021-03-09 22:19
Have you heard of the SQL Cross Apply feature but have no idea what it does? Or are you familiar with how both Cross Apply and Outer Apply work but don’t know how they can work in the… Read More
2021-03-08 19:19
If you want to see a list of databases on your server, you can run commands to do this. Let’s see how you can do this in several different SQL vendors. Summary To show a list of… Read More
2021-03-07 22:22
Sometimes you’ll need to delete a database or drop a database in SQL. There’s a command to do this in SQL. Let’s see how you can do this in different databases. Drop… Read More
2021-03-04 23:00
PostgreSQL has quite a lot of features for storing and working with JSON data. In this guide, you’ll learn: What JSON is and why you might want to use it Creating a table to store JSON… Read More
2021-03-04 04:47
Do you need to get a list of all the tables in your SQL database? Learn how to do this in several different database vendors in this guide. SQL Show Tables Sometimes you need to get a… Read More
2021-03-04 01:30
The basic UPDATE statement in SQL allows us to update data in a table. But what if we want to update data in one table based on data in another table? There are a few ways to do that in diff… Read More
2021-03-03 20:15
In this guide, you’ll learn what the DBMS_OUTPUT.PUT_LINE function in Oracle does, see some examples, learn how to enable it in different editors, and learn why it should not be used i… Read More
2021-03-03 04:34
Many SQL queries that we write need to use values provided from other areas, such as user input or an application. There are a couple of ways to include these values in your queries, but the… Read More
2021-03-02 22:43
Oracle has quite a few features for storing and working with JSON data. In this guide, you’ll learn: What JSON is and why you might want to use it Creating a table to store JSON data H… Read More
2021-02-28 20:35
Do you want to practice your SQL, database, or data analysis skills? If so, you’ll need some data, or a data set, to work on. On this page, you can find a list of several hundred data… Read More
2021-02-24 23:04
SQL Server has quite a few features for storing and working with JSON data. In this guide, you’ll learn: What JSON is and why you might want to use it Creating a table with a JSON fiel… Read More
2021-02-23 19:54
SQL injection is a type of vulnerability that software developers aim to avoid. In this guide, you’ll learn: what SQL injection is examples of SQL injection how to prevent SQL injectio… Read More
2021-02-17 19:26
Indexes in SQL are an important part of the language. But why is that? What are SQL indexes? And why should you know about them? I’ll cover all of that in this guide. I’ll also s… Read More
2021-01-21 11:00
The SQL MIN function is used to find the lowest or minimum value. Learn how to use it and see some examples in this article. Table of Contents What is the SQL MIN Function? SQL MIN Syntax Pa… Read More
2021-01-17 10:00
SQL constraints are a feature that allow you to create rules that improve the quality of your data. Learn all about them in this guide. Table of Contents What is a Constraint and Why Should… Read More
2021-01-12 11:00
SQL aggregate functions are very useful and are some of the most commonly used functions. Learn all about SQL aggregate functions are and what they do in this article. Table of Contents What… Read More
2021-01-12 11:00
The SQL AVG function allows you to find the average value from the specified values. Learn how to use it and see some examples in this article. Table of Contents What is the SQL AVG Function… Read More
2021-01-11 23:00
2021-01-10 11:00
The SQL MAX function can be used to find the highest number in a list of numbers. Learn how to use it and see some examples in this article. Table of Contents What is the SQL MAX Function? S… Read More
2021-01-07 11:00
The SQL SUM function can be used to add numbers together. Learn how to use it and see some examples in this article. Table of Contents What is the SQL SUM Function? SQL SUM Syntax Parameters… Read More
2020-10-27 19:30
MySQL has quite a few features for storing and working with JSON data. In this guide, you’ll learn: What JSON is and why you might want to use it Creating a table with a JSON field How… Read More
2020-10-19 19:34
SQL is a common language to learn when working with software. But once you learn the basics, you’ve probably got a lot of questions about different ways to do things. How should I form… Read More
2020-10-15 19:08
If you’ve looked into SQL performance at all online, you’ve probably heard of something called an “SQL execution plan”. Or maybe you’ve heard it called a &ldquo&hell…Read More
2020-10-12 20:29
Do you have a slow SQL query? If so, you’re in the right place. In this article, you’ll learn a range of reasons why a SQL query may be slow and how to fix them. There may be a f… Read More
2020-10-04 18:48
2020-09-29 21:12
Software developers are one of the main groups of people who work with databases. Recently, I asked a range of software developer blog owners to share their advice for working with databases… Read More
2020-09-29 07:05
Do you need to save your results from a MySQL query to a CSV or text file? It’s easy to do in MySQL. You can do this using an IDE or the command line, using a built-in MySQL command. L… Read More
2020-09-17 23:08
Are you working on a MySQL database and need to import CSV data? I’ll show you how to do this in MySQL Workbench in this guide. Prerequisites To use the MySQL Workbench import C… Read More
2020-09-15 22:54
Are you looking for places to practice SQL online? This list contains many different websites that have SQL practice functionality. SQL Practice Websites Each of these websites allow… Read More
2020-09-15 20:20
2020-09-13 20:21
In this guide, you’ll learn all about the ROW_NUMBER function in SQL Server. What is the SQL ROW_NUMBER Function? The ROW_NUMBER function in SQL Server is a function that adds a… Read More
2020-09-13 01:18
Dynamic SQL is a handy feature of a database that lets you construct SQL statements in a different way. In this guide, you’ll learn: what dynamic SQL is see several examples in SQL Ser… Read More
2020-08-30 00:47
There may come a time when you need to drop all tables in a MySQL database. In this article, you’ll learn how to do that easily, both using an SQL command an inside an IDE such as MySQ… Read More
2020-08-29 22:48
Do you want to reset an identity column in your table in SQL Server so the numbers are in order? And you want to do it without recreating the table? In this article, I’ll show you how… Read More
2020-08-29 21:20
Once you create a table in SQL, you may want to rename it. This might happen if you are creating a new table to replace it, or have come up with a better name for it. In this article, you&rs&hell…Read More
2020-08-26 21:17
If you work with MySQL, there will be a point when you’ll need to create a new user. This could be for another part of the system or another developer on your team. Or perhaps you want… Read More
2020-08-13 03:10
Working with dates is something you’ll do a lot in MySQL. It helps to understand the different date data types and many of the functions that can be used with them. In this guide, we&r&hell…Read More
2020-08-11 21:07
Do you need to use SQL to add a column to your table? It’s easy to do once you know the command and the syntax. Let’s take a look at how to do it in several different databases a… Read More
2020-07-26 22:23
2020-07-20 20:06
What is an SQL window function? Why should you know about it? And what can it help you with? You may have heard of SQL window functions before, or they may be completely new to you. Learn al… Read More
2020-07-15 21:08
A common question when using MySQL is how to show all users on the database. In this guide, you’ll learn how to see a list of users. You’ll also be able to see a list of logged-i… Read More
2020-07-15 19:55
Do you need to find the current date using SQL? There are a few ways to do this in the various database vendors. Let’s take a look at them. Summary Here’s a summary of how to get… Read More
2020-07-15 05:05
SQL, or Structured Query Language, contains a range of commands for interacting with the database. This article lists all of those commands, what they do, and what they look like. All of the… Read More
2020-07-14 21:24
Creating a database is one of the first things you do when setting up a new project or installing database software. Whether you’re using Oracle, SQL Server, MySQL, or PostgreSQL (or a… Read More
2020-07-09 20:25
SQL auto increment is a feature that allows you to generate a unique number when inserting rows. Learn how to set this up in SQL Server, MySQL, PostgreSQL, and Oracle in this article. Table… Read More
2020-07-08 19:50
Do you need to insert multiple rows into an SQL database? You could do that separately using INSERT statements, but there are a few problems with this. Learn what these problems are and how… Read More
2020-07-06 21:15
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… Read More
2020-07-04 23:52
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… Read More
2020-07-04 22:02
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… Read More
2020-07-02 22:05
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. Wh… Read More
2020-07-02 19:39
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… Read More
2020-07-02 00:06
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 mea… Read More
2020-06-28 22:10
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. MySQL on Mac To start MySQL on Mac, you can use the… Read More
2020-06-28 20:23
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. How To Fix The &ldqu&hell…Read More
2020-06-27 21:05
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… Read More
2020-05-24 03:05
2020-02-01 23:20
Using a source code repository for your application code is common practice.Automated testing and build, commonly known as Continuous Integration and Deployment, is something a lot of organi… Read More
2020-01-28 18:17
Companies that develop custom software for other companies have a lot of experience working with their clients. In this article, I’ve asked a range of them to provide their advice for… Read More
2020-01-14 11:00
The SQL Server DATEDIFF function lets you find the difference between two dates in a range of different units. Learn how to use it and see a range of examples in this guide. Purpose of the S… Read More
2020-01-11 05:05
Do you want to know what the SQL data types are in different database vendors? Learn all about them and how they compare in this guide. This article applies to Oracle, SQL Server, MySQL, and… Read More
2020-01-10 11:00
Do you need to convert data in SQL Server? Looking for the format codes for the CONVERT function? Learn all about the SQL Server CONVERT function in this guide. What Is the SQL Server CONVER… Read More
2020-01-09 11:00
Many programming languages allow you to comment out code so that it does not run. SQL allows comments as well. Learn how to add SQL comments in this article. What is an SQL Comment? A commen… Read More
2020-01-08 11:00
Are you looking for an ETL or data integration tool? Look no further. This list has all of the currently available ETL tools. Use this for your research to help you decide which tool to use… Read More
2020-01-07 11:00
Are you considering using either MySQL or PostgreSQL for your next project? Read this article to find out the differences between these two databases and help decide which one to use. Postgr… Read More
2020-01-07 09:00
The Oracle ALTER TABLE statement allows you to make changes to an existing table. Learn how to use it and see some examples in this guide. This article applies to Oracle, SQL Server, MySQL… Read More
2020-01-06 11:00
Data warehouses are an important part of a business. As a developer, you’ll be involved in the data warehouse in one way or another: creating it, designing it, accessing it, or working… Read More
2020-01-05 11:00
How can you delete a table in SQL? Learn how to do this by using the SQL DROP TABLE statement in this article. This article applies to Oracle, SQL Server, MySQL, and PostgreSQL. Table of Con… Read More
2020-01-04 11:00
The SQL INSERT INTO statement is one of the most popular commands in SQL, and it’s one of the first commands you learn to use. Read how to insert data and how to use the full functiona… Read More
2020-01-02 11:00
Have you ever needed to update data that was already in a table? Learn how to do this with the SQL UPDATE Statement. This post applies to Oracle, SQL Server, MySQL, and PostgreSQL. What Is t… Read More
2019-12-30 11:00
PostgreSQL is a free and open-source database management system. It’s commonly referred to as an alternative to MySQL or MariaDB. Are you thinking about using PostgreSQL for your own p… Read More
2019-12-23 21:10
The concept of NULL is something you should know about when working with databases. In this article, you’ll learn all about NULL: what it is, why it’s different, how you can chec… Read More
Subscribe to Database Star
Get updates delivered right to your inbox!