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 (161)
  • 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)

Redis SRANDMEMBER Command Explained

Posted on October 2, 2022 by Ian

In Redis, the SRANDMEMBER command returns one or more random members from the set value store at the specified key.

If you want to remove the random member/s from the set, use the SPOP command.

Continue reading →
Redis commands, what is

Redis SPOP Command Explained

Posted on October 1, 2022 by Ian

In Redis, the SPOP command removes and returns one or more random members from the set value store at the specified key.

This command is similar to the SRANDMEMBER command in that it returns one or more random members from a set, but SPOP removes it, whereas SRANDMEMBER doesn’t.

Continue reading →
Redis commands, what is

Redis SMOVE Command Explained

Posted on September 30, 2022 by Ian

In Redis, the SMOVE command moves a member of a set from one key to another. In other words, the member is removed from the source set and added to the destination set.

Continue reading →
Redis commands, what is

Fix: “ERR Number of keys can’t be greater than number of args” when using the SINTERCARD Command in Redis

Posted on September 29, 2022 by Ian

If you’re getting an error that reads “ERR Number of keys can’t be greater than number of args” when using the SINTERCARD command, it’s probably because your first argument is the wrong value.

To fix this issue, make sure the first argument reflects the number of sets that you’re comparing.

Continue reading →
Redis errors, how to

Redis SMEMBERS Command Explained

Posted on September 28, 2022April 28, 2024 by Ian

In Redis, the SMEMBERS command returns all members of a given set. We specify the key name of the set when we call the command.

Continue reading →
Redis arrays, commands, what is

Add a Virtual Column to an Existing Table in Oracle

Posted on September 27, 2022 by Ian

If we need to add a virtual column to an existing table in Oracle Database, we can do so with the usual SQL ALTER TABLE statement.

Continue reading →
Oracle computed columns, how to

Redis SMISMEMBER Command Explained

Posted on September 26, 2022April 28, 2024 by Ian

In Redis, we can use the SMISMEMBER command to find out whether one or more members are in a given set. It’s similar to the SISMEMBER command, except that it allows us to check more than one member at a time.

The SMISMEMBER command was introduced in Redis 6.2.0.

Continue reading →
Redis arrays, commands, what is

Redis SISMEMBER Command Explained

Posted on September 25, 2022 by Ian

In Redis, we can use the SISMEMBER command to find out whether or not a set contains a given member.

Continue reading →
Redis commands, what is

Fix “ERR wrong number of arguments for ‘sintercard’ command” in Redis

Posted on September 24, 2022 by Ian

If you’re getting an error that reads “ERR wrong number of arguments for ‘sintercard’ command” in Redis, it’s because you’re calling the SINTERCARD command with the wrong number of arguments.

To fix this issue, make sure you’re passing the correct number of arguments.

Continue reading →
Redis errors, how to

Redis SINTERCARD Command Explained

Posted on September 23, 2022September 23, 2022 by Ian

In Redis, the SINTERCARD command returns the cardinality of the set which would result from the intersection of all the given sets. It’s similar to SINTER, but instead of returning the result set, it returns just the cardinality of the result.

The SINTERCARD command was introduced in Redis 7.0.0.

Continue reading →
Redis commands, what is
  • «
  • 1
  • …
  • 120
  • 121
  • 122
  • 123
  • 124
  • …
  • 391
  • »

About Database.Guide | Privacy Policy