Database.Guide

Skip to content

Beginners

  • What is a Database?
  • Database Tutorial

SQL

  • SQL Tutorial
  • SQL Reference
  • SQL Joins Tutorial
  • SQL Transactions Tutorial
  • Basic SQL Queries

Categories

  • Azure SQL Edge (17)
  • Database Concepts (99)
  • Database Tools (72)
  • DBMS (9)
  • DuckDB (152)
  • MariaDB (424)
  • Microsoft Access (17)
  • MongoDB (265)
  • MySQL (602)
  • NoSQL (8)
  • Oracle (301)
  • PostgreSQL (480)
  • Redis (210)
  • SQL (697)
  • SQL Server (1,170)
  • SQLite (299)

Tag: lists

Looking at the GENERATE_SUBSCRIPTS() Function in DuckDB

Posted on March 24, 2025March 24, 2025 by Ian

The generate_subscripts() function in DuckDB creates a series of index values for accessing elements in an array. It can help us iterate through array indices when we need to work with array elements.

Here’s a quick look at DuckDB’s generate_subscripts() function, along with examples.

Continue reading →
DuckDB arrays, functions, lists, what is

Using CSV Mode in DuckDB CLI

Posted on January 5, 2025January 6, 2025 by Ian

DuckDB’s command line interface (CLI) provides a convenient .mode csv command that allows you to output all query results directly in CSV format. This approach differs from the COPY statement as it affects the output format of all subsequent queries until changed.

The article takes a quick look at CSV mode in the DuckDB CLI.

Continue reading →
DuckDB create query, how to, lists

Overview of the LIST_ADD() Function in MySQL

Posted on May 31, 2023June 28, 2023 by Ian

In MySQL, list_add() is a system function that adds a value to a comma-separated list of values and returns the result.

So it’s a handy function that allows us to append a value to a list.

Continue reading →
MySQL functions, lists, system functions, what is

Overview of the LIST_DROP() Function in MySQL

Posted on May 30, 2023June 28, 2023 by Ian

In MySQL, list_drop() is a system function that removes a value from a comma-separated list of values and returns the result.

Continue reading →
MySQL functions, lists, system functions, what is

Redis OBJECT IDLETIME Command Explained

Posted on September 3, 2022 by Ian

In Redis, we can use the OBECT IDLETIME command to check how many seconds has passed since the last access to a given key.

Continue reading →
Redis commands, lists, what is

Redis LTRIM Command Explained

Posted on August 31, 2022 by Ian

In Redis, the LTRIM command allows us to trim a list to a specified number of elements. We specify the starting and ending index, which is used to trim the list to just that range.

Continue reading →
Redis commands, lists, what is

Redis LSET Command Explained

Posted on August 29, 2022 by Ian

In Redis, the LSET command allows us to set a list element to a different value, based on its index.

Continue reading →
Redis commands, lists, what is

Redis LREM Command Explained

Posted on August 28, 2022 by Ian

In Redis, we can use the LREM command to remove one or more elements from a list. The number of elements removed depends on the arguments we pass.

Continue reading →
Redis commands, lists, what is

Redis LINSERT Command Explained

Posted on August 27, 2022 by Ian

In Redis, the LINSERT command allows us to insert an element into a list.

We have the choice of inserting it either before or after a specified element.

Continue reading →
Redis commands, lists, what is

Redis LPOS Command Explained

Posted on August 25, 2022 by Ian

In Redis, the LPOS command returns the index of matching elements inside a list.

Continue reading →
Redis commands, lists, what is
  • «
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • »

About Database.Guide | Privacy Policy