Home Index

1. SQL

2. MySQL

+ Case Statement

+ Designer

+ Dump

+ Duplicates

+ Fields Values

+ Formatting Ouput

+ HashRef

+ Hex to Date

+ Installation

+ LongReadLen

+ Mac

+ Page Result

+ Parallel Processing

+ Parameters

+ Password

+ Random

+ fetchall hashref



apt-get autoclean
apt-get update
apt-get dist-upgrade
apt-get --purge remove mysql-server

getconf LONG_BIT - find out how many bits OS you runnig 32/64
dpkg -i  mysql-5.5.28-debian6.0-i686.deb

sudo apt-get install mysql-server mysql-client

MySQL Pager

mysql> pager less -n -i -S

MySQL Pager - The -F and -X options used with less to exit if output fits on one screen

pager less -n -i -S -F -X

Creating and "m" alias in .bashrc to run MySQL with pager command

alias m='mysql --pager="less -n -i -S -F -X" -uUser -p"Password"'