In Redis, the SUNION
command returns the members of the set resulting from the union of all of the given sets.
Author: Ian
5 Ways to Check if a Table has a Generated Column in MariaDB
Here are five ways to see whether a table contains a generated column in MariaDB.
Continue readingRedis SREM Command Explained
In Redis, the SREM
command allows us to remove one or more members from a set.
Fix “ERR syntax error” when using the SISINTERCARD Command in Redis
If you’re getting an error that reads “ERR syntax error” when using the SINTERCARD
command, it could be because your first argument is too low.
If this is the case, you can easily fix the issue by making sure that the first argument reflects the actual number of sets that you’re comparing.
Continue readingRedis SRANDMEMBER Command Explained
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.
Redis SPOP Command Explained
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.
Redis SMOVE Command Explained
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.
Fix: “ERR Number of keys can’t be greater than number of args” when using the SINTERCARD Command in Redis
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 readingRedis SMEMBERS Command Explained
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.
Add a Virtual Column to an Existing Table in Oracle
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.