Slava Rozhnev articles - 17 total
SQLtest.online - the site where you can test your SQL skills
Hello friends! I'll tell you about my new project - SQLTest.online. This is a platform for those who...
Generate Date Series in popular Databases
In this post I want to answer to frequently asked question: How I can generate date series between to...
Exploring PostgreSQL's EXCLUDE Operator: Advanced Data Constraints
Introduction In the process of designing a database, as described in my previous article, I decided...
MySQL 8.0: Invisible Columns
The Oracle company ported INVISIBLE COLUMN feature to it's little brother MySQL. Since version 8.0.23...
The power of MERGE in PostgreSQL 15
The MERGE statement is a powerful tool that can be used to perform conditional INSERT, UPDATE, or...
The old MySQL bug (detective story)
In this article I want to describe about one bug that I found in MySQL and aware you from mistakes...
Everything you wanted to know about Auto Increment but were afraid to ask
Auto-increment is a feature in databases that automatically generates a unique number for each new...
Simple query to remove duplicates from table
In this small post I want to share the simple way to remove duplicates from table. The query works in...
SQL Server 2022 - GENERATE_SERIES
T-SQL 2022 has introduced a new feature called GENERATE_SERIES that allows users to generate a series...
ChatGPT helps to fix errors in SQL code
Say hello to the newest addition to the world of artificial intelligence – ChatGPT! You may have...
PHP 8.1: MySQLi: fetch_column function
Another suggestion made by Kamil Tekiela was included in the PHP 8.1 release. Starting with this...
FETCH FIRST … ROWS WITH TIES
In this article, I want to show an innovative solution to a common problem. Find the records in the...
New in PHP 8.2: mysqli_execute_query / mysqli::execute_query
In continuation of my previous article, I want to write about another nice innovation in the mysqli...
SQL Server 2022: Logical Functions - GREATEST & LEAST
Now after SQL Server 2022 released we can test new features of T-SQL One of the long-awaited...
MySQL 8: short syntax for select all
Since MySQL 8 you can use pretty short query to select all data from table. Just use TABLE a;...
PHP 8.1: MySQLi: Bind in Execute
PHP have two libraries are mainly used to interact with the MySQL database: PDO (PHP Data Objects) -...
Online PHP & SQL sandbox with ChatGPT support
PHPize.online is a project I have been working on for the last 2 years. PHPize is an online...