首页
技术知识库
Task工作计划
网站简介
DON框架
后台管理
文章分类
JAVA
框架知识
操作系统
容器相关
数据库层
优化技术
界面编程
网络编程
开发工具
GO语言
其他
读书随笔
观影随笔
每日随笔
APP
Derby基本命令操作（备忘）[Derby]
所属分类
：[数据库层] |
创建时间
：2013-01-13 |
文章属性
：转载 |
文章来源
： |
作者
：windfly
<p> </p> <p style="margin: 0in; font-weight: bold; font-size: 16.0pt;"><span style="font-size: 10pt;">0. </span><span style="font-size: 10pt;">命令</span><span style="font-size: 10pt;">行 登录/退出</span></p> <p style="margin: 0in; font-size: 10.0pt;"><span>登录</span><span> </span></p> <p style="margin: 0in; font-size: 10.0pt;"><span> java org.apache.</span><span style="font-weight: bold;">derby</span><span>.tools.ij</span></p> <p style="">..\dirs>java org.apache.<span style="font-weight: bold;">derby</span>.tools.ij</p> <p style="">ij 版本 10.3</p> <p style="">ij></p> <p style="margin: 0in; font-size: 10.0pt;"> </p> <p style="font-size: 10pt; margin: 0in;"><span>退出</span></p> <p style="">ij> exit;</p> <p style=""> </p> <p style="font-weight: bold; font-size: 10pt; margin: 0in;">1. 创建新数据库</p> <p style="margin: 0in; font-size: 10.0pt;">connect 'jdbc:<span style="font-weight: bold;">derby</span>:mydb;create=true';</p> <p style="">ij> connect 'jdbc:<span style="font-weight: bold;">derby</span>:mydb;create=true';</p> <p style="">ij></p> <p style="font-size: 10pt; margin: 0in;">在当前目录下建立数据库目录 mydb;</p> <p style=""><DIR>log</p> <p style=""><DIR>seg0</p> <p style=""><DIR>tmp</p> <p style=""><span> </span><span> service.properties</span></p> <p style=""><span> </span><span> b.lck</span></p> <p style="font-size: 10pt; margin: 0in;"> </p> <p style="font-size: 10pt; margin: 0in;">如果已经寻在数据库 mydb,则提示：</p> <p style="font-size: 10pt; margin: 0in;">警告 01J01：未创建数据库"mydb"，而是建立到现有数据库的连接。</p> <p style="">ij> connect 'jdbc:<span style="font-weight: bold;">derby</span>:mydb;create=true';</p> <p style="">警告 01J01：未创建数据库"mydb"，而是建立到现有数据库的连接。</p> <p style="">ij></p> <p style="margin: 0in; font-size: 10.0pt;"> </p> <p style="font-weight: bold; font-size: 10pt; margin: 0in;">2. 创建新表/删除表</p> <p style="font-size: 10pt; margin: 0in;">create table mytable(number varchar(4), name varchar(10), age int, address varchar(40));</p> <p style="">ij> create table mytable(number varchar(4), name varchar(10), age int, address varchar(40));</p> <p style="">已插入／更新／删除 0 行</p> <p style="">ij></p> <p style="margin: 0in; font-size: 10.0pt;"> </p> <p style="font-size: 10pt; margin: 0in;">//删除整个表</p> <p style="font-size: 10pt; margin: 0in;">drop table mytable;</p> <p style="">ij> drop table mytable; </p> <p style="">已插入／更新／删除 0 行</p> <p style="">ij></p> <p style=""> </p> <p style="font-weight: bold; font-size: 10pt; margin: 0in;">3. 表中添加数据：</p> <p style="font-size: 10pt; margin: 0in;">insert into mytable values('1001', 'one', 20, 'street 1');</p> <p style="font-size: 10pt; margin: 0in;">insert into mytable values('1002', 'two', 22, 'street 2');</p> <p style="">ij> insert into mytable values('1001', 'one', 20, 'street 1');</p> <p style="">已插入／更新／删除 1 行</p> <p style="">ij> insert into mytable values('1002', 'two', 22, 'street 2');</p> <p style="">已插入／更新／删除 1 行</p> <p style="">ij> select * from mytable;</p> <p style=""><span>NUM&|NAME </span><span> |AGE</span><span> </span><span> |ADDRESS</span></p> <p style="">--------------------------------------------------------------------</p> <p style=""><span>1001|one </span><span> |20</span><span> </span><span> </span><span> </span><span> |street 1</span></p> <p style=""><span>1002|two </span><span> |22</span><span> </span><span> |street 2</span></p> <p style="">已选择 2 行</p> <p style="margin: 0in; font-size: 10.0pt;"> </p> <p style="font-weight: bold; font-size: 10pt; margin: 0in;">4. 查看表</p> <p style="font-size: 10pt; margin: 0in;">show tables;</p> <p style="">ij> show tables;</p> <p style=""><span>TABLE_SCHEM </span><span> |TABLE_NAME</span><span> </span><span> |REMARKS</span></p> <p style="">------------------------------------------------------------------------</p> <p style=""><span>SYS </span><span> |SYSALIASES</span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSCHECKS</span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSCOLPERMS</span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSCOLUMNS</span><span> </span><span> </span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSCONGLOMERATES</span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSCONSTRAINTS</span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSDEPENDS</span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSFILES</span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSFOREIGNKEYS</span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSKEYS</span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSROUTINEPERMS</span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSSCHEMAS</span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSSTATEMENTS</span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSSTATISTICS</span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSTABLEPERMS</span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSTABLES</span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSTRIGGERS</span><span> </span><span> |</span></p> <p style=""><span>SYS </span><span> |SYSVIEWS</span><span> </span><span> |</span></p> <p style=""><span>SYSIBM </span><span> |SYSDUMMY1</span><span> </span><span> |</span></p> <p style=""><span>APP </span><span> |MYTABLE</span><span> </span><span> |</span></p> <p style="font-size: 10pt; margin: 0in;">最后一个是我们自己创建的表 MYTABLE</p> <p style="margin: 0in; font-size: 10.0pt;"> </p> <p style="font-weight: bold; font-size: 10pt; margin: 0in;">5. 查看表的结构</p> <p style="font-size: 10pt; margin: 0in;">describe mytable;</p> <p style="">ij> describe mytable;</p> <p style=""><span>COLUMN_NAME </span><span> |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&</span></p> <p style="">------------------------------------------------------------------------------</p> <p style=""><span>NUMBER </span><span> |VARCHAR |NULL|NULL|4</span><span> </span><span> |NULL</span><span> </span><span> |8</span><span> </span><span> |YES</span></p> <p style=""><span>NAME </span><span> |VARCHAR |NULL|NULL|10</span><span> </span><span> |NULL</span><span> </span><span> |20</span><span> </span><span> |YES</span></p> <p style=""><span>AGE </span><span> |INTEGER |0</span><span> </span><span> |10 |10</span><span> </span><span> |NULL</span><span> </span><span> |NULL</span><span> </span><span> |YES</span></p> <p style=""><span>ADDRESS </span><span> |VARCHAR |NULL|NULL|40</span><span> </span><span> |NULL</span><span> </span><span> |80</span><span> </span><span> |YES</span></p> <p style="">已选择 4 行</p> <p style="">ij></p> <p style="margin: 0in; font-size: 10.0pt;"> </p> <p style="font-weight: bold; font-size: 10pt; margin: 0in;">6. 表中添加数据</p> <p style="font-size: 10pt; margin: 0in;">insert into mytable values('1001', 'one', 20, 'street 1');</p> <p style="font-size: 10pt; margin: 0in;">insert into mytable values('1002', 'two', 22, 'street 2');</p> <p style="">ij> insert into mytable values('1001', 'one', 20, 'street 1');</p> <p style="">已插入／更新／删除 1 行</p> <p style="">ij> insert into mytable values('1002', 'two', 22, 'street 2');</p> <p style="">已插入／更新／删除 1 行</p> <p style="">ij></p> <p style="margin: 0in; font-size: 10.0pt;"> </p> <p style="font-weight: bold; font-size: 10pt; margin: 0in;">7. 查询数据</p> <p style="font-size: 10pt; margin: 0in;">select * from mytable;</p> <p style="font-size: 10pt; margin: 0in;">select number, name from mytable;</p> <p style="">ij> select * from mytable;</p> <p style=""><span>NUM&|NAME </span><span> |AGE</span><span> </span><span> |ADDRESS</span></p> <p style="">--------------------------------------------------------------------</p> <p style=""><span>1001|one </span><span> |20</span><span> </span><span> |street 1</span></p> <p style=""><span>1002|two </span><span> |22</span><span> </span><span> |street 2</span></p> <p style="">已选择 2 行</p> <p style="">ij> select number, name from mytable;</p> <p style="">NUM&|NAME</p> <p style="">---------------</p> <p style="">1001|one</p> <p style="">1002|two</p> <p style="">已选择 2 行</p> <p style="margin: 0in; font-size: 10.0pt;"> </p> <p style="font-weight: bold; font-size: 10pt; margin: 0in;">8. 更新数据</p> <p style="font-size: 10pt; margin: 0in;">update mytable set where number = '1001';</p> <p style="">ij> update mytable set where number = '1001';</p> <p style="">已插入／更新／删除 1 行</p> <p style="">ij> select * from mytable;</p> <p style=""><span>NUM&|NAME </span><span> |AGE</span><span> </span><span> |ADDRESS</span></p> <p style="">--------------------------------------------------------------------</p> <p style=""><span>1001|one_one </span><span> |20</span><span> </span><span> |street 1</span></p> <p style=""><span>1002|two </span><span> |22</span><span> </span><span> |street 2</span></p> <p style="">已选择 2 行</p> <p style="">ij></p> <p style="margin: 0in; font-size: 10.0pt;"> </p> <p style="font-weight: bold; font-size: 10pt; margin: 0in;">9. 删除表中数据，保留表格式</p> <p style="font-size: 10pt; margin: 0in;">delete from mytable where ;</p> <p style="font-size: 10pt; margin: 0in;">delete from mytable;</p> <p style="">ij> delete from mytable where ;</p> <p style="">已插入／更新／删除 1 行</p> <p style="">ij> select * from mytable;</p> <p style=""><span>NUM&|NAME </span><span> |AGE</span><span> </span><span> |ADDRESS</span></p> <p style="">--------------------------------------------------------------------</p> <p style=""><span>1001|one_one </span><span> |20</span><span> </span><span> |street 1</span></p> <p style="">已选择 1 行</p> <p style="">ij> delete from mytable;</p> <p style="">已插入／更新／删除 1 行</p> <p style="">ij> select * from mytable;</p> <p style=""><span>NUM&|NAME </span><span> |AGE</span><span> </span><span> |ADDRESS</span></p> <p style="">--------------------------------------------------------------------</p> <p style="">已选择 0 行</p> <p style="">ij> describe mytable;</p> <p style=""><span>COLUMN_NAME </span><span> |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&</span></p> <p style="">------------------------------------------------------------------------------</p> <p style=""><span>NUMBER </span><span> |VARCHAR |NULL|NULL|4</span><span> </span><span> |NULL</span><span> </span><span> |8</span><span> </span><span> |YES</span></p> <p style=""><span>NAME </span><span> |VARCHAR |NULL|NULL|10</span><span> </span><span> |NULL</span><span> </span><span> |20</span><span> </span><span> |YES</span></p> <p style=""><span>AGE </span><span> |INTEGER |0</span><span> </span><span> |10 |10</span><span> </span><span> |NULL</span><span> </span><span> |NULL</span><span> </span><span> |YES</span></p> <p style=""><span>ADDRESS </span><span> |VARCHAR |NULL|NULL|40</span><span> </span><span> |NULL</span><span> </span><span> |80</span><span> </span><span> |YES</span></p> <p style="">已选择 4 行</p> <p style="">ij></p> <p style="margin: 0in; font-size: 10.0pt;"> </p>
返回
