In redis, how do I remove keys?

Question

I want to remove the keys matching "user *".

how to do it on the redis command line?

Answer 1

Now it is not a function to be able to do it in one shot (see comments in the DEL documentation ). Unfortunately, you only stay with KEYS , scrolling through the results, and then using DEL to delete each one.

How to use bash a bit to help?

 for key in `echo 'KEYS user*' | redis-cli | awk '{print $1}'` do echo DEL $key done | redis-cli 

To get through it:

• echo 'KEYS user*' | redis-cli | awk '{print $1}' echo 'KEYS user*' | redis-cli | awk '{print $1}' - get all the keys and cross out the excess text that you don't want with awk.
• echo DEL $key - create an echo statement for each of them to remove it.
• | redis-cli | redis-cli - take DEL statements and pass them back to cli.

Do not indicate that this is the best approach (you may have some problems if some of your usernames have spaces in them, but hopefully you understand).

Answer 2

Another compact single line I use to do what you need:

 redis-cli KEYS "user*" | xargs redis-cli DEL 

Answer 3

In addition to orangeoctopus answer you don't need echo and pipe, you can pass commands as arguments to redis-cli . That means you can do

 for key in `redis-cli "KEYS" "user*" | awk '{print $1}'` do redis-cli "DEL" "$key" done 

Answer 4

Using awk , find all the relevant keys from redis using the redis-cli KEYS command redis-cli KEYS command and pipe to redis-cli DEL .

 redis-cli KEYS "user*" | awk '{ system("redis-cli DEL " $1) }' 

Answer 5

I know this is out of date, but for those who came here, Google:

I just published a command line interface utility for npm and github that allows you to remove keys that match a given pattern (even if you asked the user) from the Redis database.

You can find the utility here:

https://www.npmjs.com/package/redis-utils-cli

Answer 6

When using oneliner, you can edit the template in case it eludes certain characters. For example, to remove patterns such as "\ b test \ b", use:

 redis-cli --raw KEYS '\\b*' | sed 's/\\b/\\\\b/g' | xargs redis-cli del 

Answer 7

Use this to remove backslash redis keys, quotes, double quotes, or spaces:

redis-cli KEYS "user*" | sed 's/\\/\\\\/g' | sed 's/"/\\"/g' | sed "s/'/\\\\'/g" | sed 's/ /\\ /g' | xargs redis-cli DEL