wordpress 的 schema

ver 2.7: 幾個查詢例: SELECT m.* FROM wp_posts p , wp_postmeta m where p.id=m.post_id order by post_id desc SELECT tr.* FROM wp_posts p , wp_term_relationships tr where p.id=tr.object_id order by p.id desc SELECT p.id , w.* FROM wp_posts p , wp_term_relationships…

gentoo emerge php options

2009.0630 Monster LAMP Pack: 取消 : ncurses pdo readline spell 增加 : ctype json sockets berkdb gdbm xmlreader xmlwriter oci8-instant-client USE=”apache2 berkdb bzip2 calendar cjk cli crypt ctype curl gd gdbm hash iconv json mysql mysqli nls oci8-instant-client pcre reflection…

Simple Monster Tracking System – step by step

mts.js , 網上範例很多 , 這個是基本型: 這段 code 前面就是一連串的組出 z 變數(包括 OS , BROWSER , SCREEN WIDTH/HEIGHT …) , 然後用一個小點透過 apache 的 log 記錄下來. 這個 apache 要裝 mod_setenvif 或 mod_rewrite modules , 在 apache config 中設定 只 log 特定的 tracking data.…

MySQL – Optimizing Database Structure

參考: http://dev.mysql.com/doc/refman/5.0/en/optimizing-database-structure.html 7.4.1. Make Your Data as Small as Possible 7.4.2. Column Indexes 7.4.3. Multiple-Column Indexes 7.4.4. How MySQL Uses Indexes 7.4.5. The MyISAM Key Cache 7.4.6. MyISAM Index Statistics Collection 7.4.7. How MySQL Opens and Closes Tables 7.4.8. Disadvantages…

mysql index 的建立/使用 , Multiple-Column Indexes

http://dev.mysql.com/doc/refman/5.0/en/multiple-column-indexes.html CREATE TABLE test ( id INT NOT NULL, last_name CHAR(30) NOT NULL, first_name CHAR(30) NOT NULL, PRIMARY KEY (id), INDEX name (last_name,first_name) ); The name index is an index over the last_name and first_name columns. The index can be…