«
»

wordpress 的 schema

2009/06/30, 4:35 pm

ver 2.7:

wp_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 tr , wp_term_taxonomy t
where p.id=tr.object_id
and tr.term_taxonomy_id=t.term_taxonomy_id
order by p.id desc

SELECT p.id , w.*
FROM  wp_posts  p , wp_term_relationships tr , wp_term_taxonomy t ,  wp_terms w
where p.id=tr.object_id
and tr.term_taxonomy_id=t.term_taxonomy_id
and t.term_id = w.term_id
order by p.id desc
Tags: ,
Category: DATABASE, Programming/php

Comments are closed.

Related URL:
  1. install oracle 11g steps
  2. 一些 memcache 的資料
  3. Protected: Oracle down time / problem records / 經典
  4. Database administrator
  5. 在 gentoo 裝 oracle sqlplus package
  6. Graphical Database Schema Metadata Browser – SchemaSpy
  7. Oracle documentation library
  8. MySQL – Optimizing Database Structure
  9. Protected: 規格表 schema
  10. mysql index 的建立/使用 , Multiple-Column Indexes