Skip to content

Instantly share code, notes, and snippets.

Keybase proof

I hereby claim:

  • I am marlomgirardi on github.
  • I am marlom (https://keybase.io/marlom) on keybase.
  • I have a public key ASDsmSBzCGbzaKLf63cVI2lX30nJLqdKCw9Y9PAwIvu7iwo

To claim this, I am signing this object:

# 1. Get Kernels
# 2. Filter installed only
# 3. Remove current kernel from list
# 4. Purge all kernels on list
# 5. Auto-remove
# 6. Update grub list
sudo dpkg --list 'linux-image*' | \
awk '{ if ($1=="ii") print $2}' | \
grep -v `uname -r` | \
@marlomgirardi
marlomgirardi / find-fks-to.sql
Created April 11, 2018 11:40
MySQL Utilities
-- ------------------
-- FIND FK TO A TABLE
SELECT
TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
REFERENCED_TABLE_SCHEMA = '<database>' AND
REFERENCED_TABLE_NAME = '<table>';