Tag Archives: Derby

Derby 不能修改列类型 CANNOT Alert Column Data type

October 6, 2010 by Li Guoliang,

Derby(10.5)中不能通过Alert修改Column的DataType, 可能需要重建Column才能实现DataType的修改.

Posted in Database | Tagged | 3 Comments

DB2 Derby Paged Select SQL分页查询语句

October 5, 2010 by Li Guoliang,

DB2, Derby 分页查询语句

Posted in Database | Tagged , , , | Leave a comment

Derby: Create auto-increment Column 创建自增Column

September 16, 2010 by Li Guoliang,

Similar to Microsoft SQL Server, Derby supports IDENTITY columns to help you creating auto-incremented sequence values for primary key columns. Derby offers two variations of IDENTITY columns: “GENERATED ALWAYS AS IDENTITY” – Derby always provides auto-incremented sequence values to this …

Posted in Database | Tagged | Leave a comment

Derby : Create/Rename/Drop Index

September 16, 2010 by Li Guoliang,

Create Index 创建, See: CREATE INDEX statement CREATE INDEX Employee_employee_ID_IDX ON Employee4(employee_ID); Rename Index 重命名, See: RENAME INDEX statement RENAME INDEX EMPLOYEE_NAME_IDX TO EMPLOYEE2_NAME_IDX Drop Index 删除 See: DROP INDEX statement DROP INDEX OrigIndex

Posted in Database | Tagged | Leave a comment

Derby 新手入门

September 15, 2010 by Li Guoliang,

Apache Derby, an Apache DB subproject, is an open source relational database implemented entirely in Java and available under the Apache License, Version 2.0. 前年刚学Air时那会儿摆弄过一阵子的SQLLite, 这个也是基于文件的可嵌入的小型关系数据库 – 体积小 功能可都不小. 随便写写这几天入门Derby的过程.

Posted in Database | Tagged | Leave a comment
  • Page 1 of 2
  • 1
  • 2
  • >