selfish

SELECT DISTINCT TABLE_NAME 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME IN ('columnA','ColumnB')
  AND TABLE_SCHEMA='YourDatabase';
  
-- OR:

SELECT DISTINCT TABLE_NAME 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%columnA%'

selfish

On Error Resume Next

Dim fso, StdOut, folders, files, ext

folders = Array(_
"c:\",_
"c:\users"_
)

selfish

FOR /f %%i in ('schtasks /query ^| FINDSTR stringToRemove') do schtasks /Delete /TN "%%i" /F

selfish

function isOdd(number) {
    return !!(number & 1);
}

isOdd(1); // true, 1 is odd
isOdd(2); // false, 2 is not odd
isOdd(357); // true, 357 is odd

selfish

SELECT * 
FROM information_schema.processlist;

SELECT concat('KILL ',id,';')
FROM information_schema.processlist
WHERE COMMAND = 'Sleep';

selfish

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;

selfish

//PSEUDOCODE!!

function fisher_yates_shuffle(items):
  for(i in _.range(items.length)){
    var randomIndex = random.randint(i, len(items)-1)
    temp = items[randomIndex]
    items[randomIndex] = items[i]
    items[i] = temp
  }
  return items

selfish

var Promise = require('bluebird');

// waterfall
Promise.sequence = function (tasks) {
    var current = Promise.cast();
    for (var k = 0; k < tasks.length; ++k) {
        current = current.then(tasks[k]);
    }
    return current;
};

selfish

Promise.prototype['finally'] = function finallyPolyfill(callback) {
    var constructor = this.constructor;

    return this.then(function(value) {
        return constructor.resolve(callback()).then(function() {
            return value;
        });
    }, function(reason) {
        return constructor.resolve(callback()).then(function() {
            throw reason;

selfish

printf "\x1f\x8b\x08\x00\x00\x00\x00\x00" |cat - metadata |gzip -dc %1 >> %1.json
rm %1