umanshield

SELECT City,Population FROM north_american_cities WHERE country='Canada';
SELECT city,Longitude FROM north_american_cities 
WHERE Longitude < (SELECT LONGITUDE FROM north_american_cities WHERE City='Chicago')
ORDER BY LONGITUDE ASC;

SELECT city,population FROM north_american_cities
WHERE Country ='Mexico'
ORDER BY Population desc
limit 2;

umanshield

var test1 = { a: 1, b: 2}
var test2 = Object.create(test1);

// 1. decorating pattern
var getReuseObject = function(obj, location) {
	obj.loc = location;
	return obj;
};
obj1 = getReuseObject({}, 1);

umanshield

alias gs='git status '
alias ga='git add '
alias gb='git branch '
alias gc='git commit'
alias gd='git diff'
alias go='git checkout '
alias gk='gitk --all&'
alias gx='gitx --all'

alias got='git '

umanshield

#!/bin/bash

if [ "$(whoami)" != "root" ]; then
	echo "ERROR : Run script as Root (sudo !!) please"
	exit 1
fi

read -e -p "Redis version to be installed (change if needed) : " -i "2.8.2" VERSION
echo 'Installing redis v.'$VERSION' ... '

umanshield

Setfacl for access

sudo setfacl -R -m u:www-data:rX todo-symfony
-R recursive
-m modify
u user(g- group)
rXw read execute write

var directory var/cache and var/log

sudo setfacl -R -m u:www-data:rwX var

umanshield

sudo apt-get install --no-install-recommends gnome-panel
gnome-desktop-item-edit ~/Desktop/ --create-new

umanshield

{
    "default_line_ending": "unix",
    "ensure_newline_at_eof_on_save": true,
    "rulers":
    [
        80,
        120
    ],
    "tab_size": 4,
    "translate_tabs_to_spaces": true,

umanshield

tar -cf txt.tar *.txt  # -f упаковка
tar -cvzf files.tar.gz ~/files  # -z gzip 
tar -cvjf files.tar.bz2 ~/files # -j bzip2
tar --exclude='file1' --exclude='patter*' --exclude='file2' 

#Распаковка архив
tar -xvf /path/to/archive.tar.bz2
tar -xvf archive.tar.bz2 -C /path/to/folder #-C path/to/folder -куда

#Просмотр содержимого архива

umanshield

<IfModule mod_rewrite.c>
    Options +FollowSymlinks
    RewriteEngine On

    # Explicitly disable rewriting for front controllers
    RewriteRule ^/web/app_dev.php - [L]
    RewriteRule ^/web/app.php - [L]

    # Fix the bundles folder
    RewriteRule ^bundles/(.*)$ /web/bundles/$1  [QSA,L]

umanshield

multicursor   cmd(win key)+alt+click