Basic commands

login to mysql (from linux shell)

mysql -u root -p
mysql -h hostname -u root -p

create database

mysql> create database database_name;

show all…

[ Read the rest ... ]

I need to install 2 different greasemonkey scripts to make it work.

Display 100 rows in settings pages

• install Firefox
• install Greasemonkey plugin
• install this greasemonkey script:

…

[ Read the rest ... ]

美国英文版

Windows 7 Ultimate (x86) – DVD (English)

文件名 en_windows_7_ultimate_x86_dvd_x15-65921.iso 邮寄日期 (UTC)： 8/6/2009 9:59:56 AM
SHA1: 5395DC4B38F7BDB1E005FF414DEEDFDB16DBF610 ISO/CRC: C1C20F76

ed2k://|file|en_windows_7_ultimate_x86_dvd_X15-65921.iso|2501894144|09902C7687C9CA86BD935BD0EFB61D3A|/

Windows 7 Ultimate (x64) – DVD (English)…

[ Read the rest ... ]

一、 windows7 简体中文资源MSDN原版下载与SHA1值校验

0.Windows 7 Starter (x86)

文件名 cn_windows_7_starter_x86_dvd_x15-69303.iso
ISO/CRC: 17C3FF16
SHA1: C9B9F3143328AFE62BF3EACA164BE02B17B04532
下载 2,483.60 (MB)

ed2k://|file|cn_windows_7_starter_x86_dvd_x15-69303.iso|2604238848|5A6796B2B6A97B3E372F7C37D3A42AA4|/

文件名 cn_windows_automated_installation_kit_for_windows_7_and_windows_server_2008_r2_x86_x64_ia64_dvd_400075.iso
ISO/CRC: 8079B9B3
SHA1: 02956D721650D0FFE6D7070315F4D899116E821D…

[ Read the rest ... ]

香港版：
家庭高级版：
语言：中文(中国香港)
文件名：hk_windows_7_home_premium_x64_dvd_x15-65722.iso
邮寄日期(UTC)：2009-8-21 9:48:05
文件大小：3313936384 字节
SHA1：6B6D270829FD83600ED2AB9096D125CE83E45584

ed2k://|file|hk_windows_7_home_premium_x64_dvd_x15-65722.iso|3313936384|89A775C883FEC124572040F0C4169155|/

语言：中文(中国香港)
文件名：hk_windows_7_home_premium_x86_dvd_x15-65721.iso
邮寄日期(UTC)：2009-8-21 9:48:05
文件大小：2574176256 字节
SHA1：9A22859DD52E7E7C30BA2DBFAC1D286FF08AD77A

ed2k://|file|hk_windows_7_home_premium_x86_dvd_x15-65721.iso|2574176256|755F421B4E7A9BD6483E86096D0E6216|/

…

[ Read the rest ... ]

Prepare

login as root

zypper ref
zypper up

Install Sun Java JDK

zypper in -l java-1_6_0-sun java-1_6_0-sun-devel java-1_6_0-sun-jdbc java-1_6_0-sun-plugin

Install Ant and Subversion

zypper in

…

[ Read the rest ... ]

If you want to change a Wordpress database from InnoDB to MyIsam.

• make a backup of your database first
• open your phpMyAdmin, paste in the following codes

…

[ Read the rest ... ]

Open phpMyAdmin, make a backup of your database first

Find all un-used tags

SELECT * From wp_terms wt
INNER JOIN wp_term_taxonomy wtt ON wt.term_id=wtt.term_id WHERE wtt.taxonomy='post_tag' AND wtt.count=0;

…

[ Read the rest ... ]

人之初 口多多; 笑騎騎 放毒蛇; 馬照跑 女照搞; 舞照跳 雞照叫;
識少少 扮代表; 眼大大 易學壞; 牙斬斬 死得慘; 眼眨眨 扮花旦;
周身郁 扮忙碌; 靜雞雞 認低威; 有早知 無乞兒; 有早知 中三Ｔ;
有得振 無得訓; 搞搞振 無幫襯; 側側膊

…

[ Read the rest ... ]

there are two ways to wrap long programming code or command lines

Method 1

use <pre style="white-space: normal;"> and </pre> around the code

Example:

• Long command lines example

…

[ Read the rest ... ]