Tag Archives: SQL

使用JDBC获取DB2的所有表(getTables)

October 2, 2010 by Guoliang, 272 views

直接使用metadata.getTables似乎不能获取DB2中指定Database下的所有Table, 但可使用如下语句获取:
"SELECT CREATOR,NAME FROM SYSIBM.SYSTABLES WHERE CREATOR NOT LIKE ‘SYS%&#

Posted in DB | Tagged DB2, getTables, JDBC, SQL | Leave a comment

March 29, 2009 by Guoliang, 717 views

支持数据库:

SQL Server, MySQL, PostgreSQL, Oracle, DB2, ANSI SQL, ODBC

演示:

Posted in 其他技术 | Tagged MySQL, SQL | Leave a comment

November 17, 2008 by Guoliang, 1,291 views

1. Attribute : [普] 属性, 品质, 特征
Represents[表现,描绘] a type of characteristic or property with a set of real or abstract things(People, Places, Events and

Posted in 计算机英语 | Tagged ERwin, SQL, 菜鸟学计算机英语 | 1 Comment

有两个表,如下:
mysql> SELECT * FROM Class; +———-+——–+ | Class_ID | Name | +———-

Posted in 其他技术 | Tagged Join, MySQL, SQL | Leave a comment

使用工具: phpMyAdmin, MySQLBroswer, 命令提示行[Windows下须将mysql目录中的bin添加到环境变量PATH中].
1. 连接的建立与退出:
mysql –u root –p 或登陆后直接选定某数据库 mysql –u root –p [数据库名称]

Posted in 其他技术 | Tagged MySQL, SQL | Leave a comment