Skip to content

Instantly share code, notes, and snippets.

View XHMM's full-sized avatar
:octocat:
Tomorrow should be better

xiao xin XHMM

:octocat:
Tomorrow should be better
View GitHub Profile
@ddre54
ddre54 / redis_keys_clear_pattern_matching.lua
Last active December 13, 2020 16:23
Remove all the keys from redis matching a pattern
--Starting with redis 2.6.0, you can run lua scripts
EVAL "return redis.call('del', unpack(redis.call('keys', ARGV[1])))" 0 prefix:*
--For big number of keys
EVAL "local keys = redis.call('keys', ARGV[1]) \n for i=1,#keys,5000 do \n redis.call('del', unpack(keys, i, math.min(i+4999, #keys))) \n end \n return keys" 0 prefix:*

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

  • Mac /usr/local/mysql/bin
  • Windows /Program Files/MySQL/MySQL version/bin
  • Xampp /xampp/mysql/bin

Add mysql to your PATH