This is a test of the DERBY SQL template
This is the Brazil version of the simple derby demo
- Create the database
create table derbyDB(num int, addr varchar(40))
- insert an item
insert into derbyDB values (1956,'Webster St.')
- insert an item
insert into derbyDB values (1910,'Union St.')
- update an item
update derbyDB set num=180, addr='Grand Ave.' where num=1956
- get the results
SELECT num, addr FROM derbyDB ORDER BY num
=