hsqldbデータベースのバックアップ(No.4)

DIAVIS-wiki

CREATE TABLE TAGS ( ID IDENTITY, KEYWORDS VARCHAR, EVENT_ID INTEGER, DATE TIMESTAMP );

INSERT INTO image (URI) values ('JanTschichold.jpg');

select * from person  where database=0 and name like '%Hide%'  order by name

select * from person  where database=0 and UPPER(name) like '%HIDE%'  order by name

select * from person  where database=0 and UPPER(name) like '%Hide%'  order by name

SELECT * FROM Orders WHERE CustomerID = 'QUICK' AND OrderDate BETWEEN '1996/1/1' AND '1997/12/31'


DIAVIS-wiki バックアップ一覧ソースを表示 hsqldbデータベースは削除されています。 1 (2006-11-26 (日) 17:07:29) 2 (2006-11-26 (日) 17:45:58) 3 (2007-01-11 (木) 20:27:25) 4 (2007-01-12 (金) 15:38:18) 5 (2007-01-13 (土) 15:36:06) 6 (2007-01-20 (土) 21:13:51) 7 (2007-01-24 (水) 15:55:02) 8 (2007-01-25 (木) 11:08:28) 9 (2007-01-25 (木) 16:09:52) 10 (2007-02-01 (木) 04:13:43) 11 (2007-02-05 (月) 15:13:10) 12 (2007-05-04 (金) 11:30:51) 13 (2007-05-09 (水) 04:20:16) 14 (2007-05-10 (木) 03:58:57) 15 (2007-05-10 (木) 07:09:00) 16 (2007-08-31 (金) 08:47:25) 17 (2007-08-31 (金) 19:42:21) ↑ CREATE TABLE TAGS ( ID IDENTITY, KEYWORDS VARCHAR, EVENT_ID INTEGER, DATE TIMESTAMP ); ↑ ↑ INSERT INTO image (URI) values ('JanTschichold.jpg'); ↑ ↑ ↑ ↑ ↑ ↑ ↑ ↑ ↑ ↑ ↑ select * from person where database=0 and name like '%Hide%' order by name select * from person where database=0 and UPPER(name) like '%HIDE%' order by name select * from person where database=0 and UPPER(name) like '%Hide%' order by name ↑ ↑ SELECT * FROM Orders WHERE CustomerID = 'QUICK' AND OrderDate BETWEEN '1996/1/1' AND '1997/12/31' ↑