check the link: http://www.percona.com/doc/percona-server/5.5/installation.html

1. wget *.d3b

2. dpkg -i *.deb

3. apt-get -f install

http://www.markhansen.co.nz/javascript-optional-parameters/

Import is:

function connect(hostname, port, method) {
    hostname = hostname || "localhost";
    port = port || 80;
    method = method || "GET";
}

The short-circuit OR operator || returns the left side if the left argument is truthy (evaluates to truein conditionals), otherwise it checks if the right argument is truthy, returning it. We can use this shortcut because undefined is falsy: in conditionals, undefined evaluates to false.

This shortcut approach is a very common idiom, but it does have a disadvantage: You can’t use for any argument that could accept a falsy value: false, 0, null, undefined, the empty string "", and NaN.

Using the || shortcut will override any falsy input value. If you expect a falsy value, you must explicitly check for argument === undefined.

Example: to get system date for n minute ago in format like „26-Aug-2013 11:04“ , can write:

date +’%d-%b-%Y %H:%M‘ -d ‚1 minute ago‘

 

if [];
then

do sth.

fi

if you want to sort a colum  not with the standard up/ down order, you can use FIND_IN_SET in ORDER BY.

The functzion Find_in_set:

SELECT FROM FIND_IN_SET(„b“, „a,b,c“)

Just return 2, the position where matched.

Use in ODER BY Example:

SELECT * FROM Product

WHERE id IN ( 6,5,4)

ORDER BY FIND_IN_SET(id, „6,5,4“)

function parse_git_branch_and_add_brackets {
git branch –no-color 2> /dev/null | sed -e ‚/^[^*]/d‘ -e ’s/* \(.*\)/\ \[\1\]/‘
}
PS1=“\h:\W \u\[\033[0;32m\]\$(parse_git_branch_and_add_brackets) \[\033[0m\]\$ “

add into .bashrc