<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
  <channel>
    <title>IT无忧论坛 - 数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</title>
    <link>http://51it.ca/bbs/forumdisplay.php?fid=75</link>
    <description>Latest 20 threads of 数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</description>
    <copyright>Copyright(C) IT无忧论坛</copyright>
    <generator>Discuz! Board by Comsenz Inc.</generator>
    <lastBuildDate>Thu, 09 Sep 2010 01:25:05 +0000</lastBuildDate>
    <ttl>60</ttl>
    <image>
      <url>http://51it.ca/bbs/images/logo.gif</url>
      <title>IT无忧论坛</title>
      <link>http://51it.ca/bbs/</link>
    </image>
    <item>
      <title>MySQL 5.5 M3 发布</title>
      <link>http://51it.ca/bbs/viewthread.php?tid=2347</link>
      <description><![CDATA[[font=verdana,Arial,Helvetica][size=12px][size=14px][font=verdana,Arial,Helvetica][size=14px]MySQL 5.5的第三个里程碑版发布了，该版本一个最大的改动就是增加了性能的元数据信息库，数据库名为 performance_schema ，采用的存储引擎是PERFORMANCE_SCHEMA，该数据库将 ...]]></description>
      <category>数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</category>
      <author>jamesl</author>
      <pubDate>Tue, 13 Apr 2010 15:49:31 +0000</pubDate>
    </item>
    <item>
      <title>NoSQL只是一阵风</title>
      <link>http://51it.ca/bbs/viewthread.php?tid=2280</link>
      <description><![CDATA[[color=#404040][font=verdana, Arial, Helvetica][font=verdana, Arial, Helvetica][size=14px]最近有多家Web 2.0企业[url=http://news.cnblogs.com/n/59779/]宣布使用[/url]非关系型数据库（NoSQL），引起了开发者对NoSQL的强烈关注。但Ted Dziuba在“[url=http://teddziub ...]]></description>
      <category>数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</category>
      <author>jamesl</author>
      <pubDate>Mon, 29 Mar 2010 23:59:28 +0000</pubDate>
    </item>
    <item>
      <title>MySQL Cheat Sheet</title>
      <link>http://51it.ca/bbs/viewthread.php?tid=1912</link>
      <description><![CDATA[Selecting a database:

mysql&gt; USE database;

Listing databases:

mysql&gt; SHOW DATABASES;

Listing tables in a db:

mysql&gt; SHOW TABLES;

Describing the format of a table:

mysql&gt; DESCRIBE table;

Creating a database:

mysql&gt;]]></description>
      <category>数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</category>
      <author>jamesl</author>
      <pubDate>Sat, 07 Nov 2009 03:01:05 +0000</pubDate>
    </item>
    <item>
      <title>SQL操作全集</title>
      <link>http://51it.ca/bbs/viewthread.php?tid=1911</link>
      <description><![CDATA[下列语句部分是Mssql语句，不可以在access中使用。

SQL分类：
DDL—数据定义语言(CREATE，ALTER，DROP，DECLARE)
DML—数据操纵语言(SELECT，DELETE，UPDATE，INSERT)
DCL—数据控制语言(GRANT，REVOKE，COMMIT，ROLLBACK)

首先,简要介绍基础语句：
1、说明：创建数据库
CR ...]]></description>
      <category>数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</category>
      <author>jamesl</author>
      <pubDate>Sat, 07 Nov 2009 02:59:45 +0000</pubDate>
    </item>
    <item>
      <title>A Few MySQL Tips You Might Not Know</title>
      <link>http://51it.ca/bbs/viewthread.php?tid=1042</link>
      <description><![CDATA[MySQL is a database server suitable for small and a little bigger sized database applications. It has been the all time favourite since its creation. It works on windows as well as Unix / Linux but when run on Unix / Linux, it can provide multithreading w]]></description>
      <category>数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</category>
      <author>jamesl</author>
      <pubDate>Fri, 21 Aug 2009 18:05:37 +0000</pubDate>
    </item>
    <item>
      <title>Ubuntu下安装Postgresql 8.3</title>
      <link>http://51it.ca/bbs/viewthread.php?tid=684</link>
      <description><![CDATA[[i=s] 本帖最后由 davidzhang 于 2009-8-8 14:01 编辑 [/i]

测试环境：Ubuntu 8.04
在Ubuntu下安装Postgresql和pgAdmin3[/b]

sudo apt-get install postgresql-8.3 postgresql-client-8.3 postgresql-contrib-8.3

sudo apt-get install pgadmin3

以上指令安装客户端和服 ...]]></description>
      <category>数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</category>
      <author>davidzhang</author>
      <pubDate>Sat, 08 Aug 2009 18:00:02 +0000</pubDate>
    </item>
    <item>
      <title>Install Oracle 11g on Ubuntu 9.0.4</title>
      <link>http://51it.ca/bbs/viewthread.php?tid=465</link>
      <description><![CDATA[1. Install JRE or JDK 1.6[/b]
2. Install the required packages[/b] (please follow the Oracle installation guide)
# apt-get install gcc
Do the same for other packages
make binutils lesstif2 rpm libmotif3 libaio gawk alien ksh
3.create the directories[]]></description>
      <category>数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</category>
      <author>davidzhang</author>
      <pubDate>Thu, 30 Jul 2009 18:53:12 +0000</pubDate>
    </item>
    <item>
      <title>SQL for Dummies 5th</title>
      <link>http://51it.ca/bbs/viewthread.php?tid=444</link>
      <description><![CDATA[SQL For Dummies, 5th Edition Summary:[/b]  [align=left][size=2]* SQL is the international standard database language used to create, access, manipulate, maintain, and store information in a relational database management system (DBMS)-a vital tool for dat]]></description>
      <category>数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</category>
      <author>jamesl</author>
      <pubDate>Wed, 29 Jul 2009 21:55:13 +0000</pubDate>
    </item>
    <item>
      <title>Learn basic SQL commands</title>
      <link>http://51it.ca/bbs/viewthread.php?tid=405</link>
      <description><![CDATA[I got this article last night, hope it helps.

Learn basic SQL commands]]></description>
      <category>数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</category>
      <author>davidzhang</author>
      <pubDate>Mon, 27 Jul 2009 13:13:27 +0000</pubDate>
    </item>
    <item>
      <title>For.Dummies.Oracle.11g.For.Dummies.Jan.2009</title>
      <link>http://51it.ca/bbs/viewthread.php?tid=356</link>
      <description><![CDATA[For.Dummies.Oracle.11g.For.Dummies.Jan.2009,希望对大家有用！]]></description>
      <category>数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</category>
      <author>davidzhang</author>
      <pubDate>Tue, 21 Jul 2009 23:53:44 +0000</pubDate>
    </item>
    <item>
      <title>For.Dummies.Oracle.11g.For.Dummies.Jan.2009</title>
      <link>http://51it.ca/bbs/viewthread.php?tid=355</link>
      <description><![CDATA[For.Dummies.Oracle.11g.For.Dummies]]></description>
      <category>数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</category>
      <author>davidzhang</author>
      <pubDate>Tue, 21 Jul 2009 23:48:03 +0000</pubDate>
    </item>
    <item>
      <title>软件测试人员需掌握的SQL操作全集（二）</title>
      <link>http://51it.ca/bbs/viewthread.php?tid=309</link>
      <description><![CDATA[10、说明：两张关联表，删除主表中已经在副表中没有的信息

        delete from table1 where not exists ( select * from table2 where table1.field1=table2.field1 )

11、说明：四表联查问题：

        select * from a left inner join b on a.a=b.b right inner join ...]]></description>
      <category>数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</category>
      <author>davidzhang</author>
      <pubDate>Sun, 19 Jul 2009 19:39:10 +0000</pubDate>
    </item>
    <item>
      <title>软件测试人员需掌握的SQL操作全集(一)</title>
      <link>http://51it.ca/bbs/viewthread.php?tid=308</link>
      <description><![CDATA[[i=s] 本帖最后由 davidzhang 于 2009-7-19 15:37 编辑 [/i]

下列语句部分是Mssql语句，不可以在access中使用。

        SQL[/b][/u]分类：

        DDL—数据定义语言(CREATE，ALTER，DROP，DECLARE)

        DML—数据操纵语言(SELECT，DELETE，UPDATE，INSERT)

      ...]]></description>
      <category>数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</category>
      <author>davidzhang</author>
      <pubDate>Sun, 19 Jul 2009 19:36:04 +0000</pubDate>
    </item>
    <item>
      <title>Microsoft SQL Server 2005安装使用教程</title>
      <link>http://51it.ca/bbs/viewthread.php?tid=275</link>
      <description><![CDATA[根据微软帮助制作而成,简单的介绍了如何安装SQL Server 2005, 适合新手.

241[/attach]]]></description>
      <category>数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</category>
      <author>jamesl</author>
      <pubDate>Sun, 19 Jul 2009 00:05:29 +0000</pubDate>
    </item>
    <item>
      <title>Sams Teach Yourself Microsoft® SQL Server™ 2005 Express in 24 Hours</title>
      <link>http://51it.ca/bbs/viewthread.php?tid=102</link>
      <description><![CDATA[入门推荐教程，简单明了，我曾经完全读过。]]></description>
      <category>数据库(Oracle/SQL Server/DB2/MySQL/Postgresql)</category>
      <author>jamesl</author>
      <pubDate>Tue, 07 Jul 2009 03:40:40 +0000</pubDate>
    </item>
  </channel>
</rss>