rm - all files without confirmation

rm -f *

mysql - check granted permissions on all users

SELECT * FROM `information_schema`.`USER_PRIVILEGES`;

wget import url from txt file

wget -i filelist.txt

apt-update - change update server

nano /etc/apt/sources.list
for ukrainian mirror only this file should look like this:


deb http://ftp.ua.debian.org/debian/ squeeze main contrib non-free
deb-src http://ftp.ua.debian.org/debian/ squeeze main contrib non-free


list of source servers for debain squeeze
http://how-to.linuxcareer.com/debian-apt-get-squeeze-sourceslist

sql-extract timepart from datetime

select convert(varchar(10), sysdate, 108)

sql-is not null

expression IS [ NOT ] NULL

print defined column from ls -la result

ls -l | awk '{ print $2 }' - print column #2