Tag: SQL

Preamble​​Sometimes you need to select random entries from a table, for example: Highlight a few random blog posts and display them in the sidebar.Choose a random quote to display the Quote of...

Preamble​​The MySQL development team is pleased to announce the release of a new 8.0 version to support MySQL Shell AdminAPI – 8.0.20!After the previous exciting release, which introduced...

Preamble​​PostgreSQL, often referred to simply as Postgres, is a universal open-source object and relational database management system.Knowing which version of the PostgreSQL server is installed...

Preamble​​It is easy to select the highest or lowest entry in the database table using the MAX or MIN function. However, it is a bit difficult to select the n highest record. For example, to get...

Preamble​​In this article, you will learn how to emulate the row_number() function in MySQL. We will show you how to add a sequential integer to each line or group of lines in the result set.Note...

In this article, there are 8 concepts to understand if you want to become an advanced programmer faster. The list is not complete, but it can be a good starting point for self-education in...

What is the cause of the vulnerability?According to the WordPress command, the WordPress kernel is not in immediate danger, but the new version will add additional protection in case plugins or...

In this article, you will learn how to display NULL values in other meaningful values.Dr.EFCodd, who is the creator of the relational model for the database, introduced this concept of NULL...

There are many PostgreSQL manuals on the network that describe the basic commands. But as you dive deeper into the work, you'll encounter practical issues that require advanced commands.Such...

Previously, SQL as a tool was enough for research analysis: quick data search and preliminary report on data.Nowadays, data come in different forms and do not always refer to them as...

Many developers, even those who have long been familiar with SQL, do not understand window functions, considering them some kind of special magic for the chosen ones. And although the...

Preamble​​SQL or Structured Query Language (Structured Query Language) is intended for data management in a relational database system (RDBMS). In this article, you will learn about frequently...

Preamble​​When you need to select a DBMS, the main question is usually to select a relational (SQL) or non-relational (NoSQL) structure. Both options have their advantages, as well as several key...

While there are different types of SQL tools available on the market, you need to evaluate and find out which one is best suited for which circumstances.Some tools offer high performance with...

There are several ways to connect to a MySQL database in PHP. The most common are the MySQL API, MySQLi API, and PDO API (PHP data objects). The latter two support more functions than the old...

SQL (Structured Query Language) is a simple language, but it is not as simple when you work with datasets that contain millions of records.When you work with medium and large tables, writing...