Maintaining relationship – common friends
I was posed a very trivial question from one of my friends recently. It picked my interest, since I could not readily solve it, and… Read More »Maintaining relationship – common friends
sql
SQL JOINS quick tutorial
Table T1, Table T2 INNER JOIN returns only matching rows from T1, T2 LEFT OUTER JOIN returns (all T1 rows) X (matching T1 rows in… Read More »SQL JOINS quick tutorial
Wikimedia Downloads
Wikimedia Downloads The following kinds of downloads are available: Database backup dumps A complete copy of all Wikimedia wikis, in the form of wikitext source… Read More »Wikimedia Downloads
Set MySQL to UTF-8
Change the following in my.cnf [mysqld] default-character-set= utf8 skip-character-set-client-handshake character-set-server= utf8 collation-server= utf8_general_ci init-connect= ‘SET NAMES utf8′ via M’sNOTE MySQL(デフォルト文字コード)の設定 – Ubuntu9.04.
MySQL UTF-8
A very informative page (in Japanese) about MySQL and issues to enable correct UTF-8 data handling with client applications. View original post
MySQL’s killer feature
MySQL has a killer feature – you can have a timestamp field with DEFAULT as LOCALTIMESTAMP, so that when you insert a new record, the… Read More »MySQL’s killer feature