DIAVIS-wiki
CREATE TABLE TAGS ( ID IDENTITY, KEYWORDS VARCHAR, EVENT_ID INTEGER, DATE TIMESTAMP ); INSERT INTO image (URI) values ('JanTschichold.jpg');
ResultSet rs; rs = mSQL.executeSQL("select COUNT(*) from keyword where keyword='" + keyword + "';"); int keyword_id = -1; try { rs.next(); int nResult = rs.getInt(1); 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' select * from keyword order by latest_appearance desc select * from keyword order by num desc, latest_appearance select * from keyword order by latest_appearance desc, num desc select * from items where date BETWEEN '2007-05-01 12:00:00.0' AND '2007-05-04 15:00:00.0' order by date desc SELECT COUNT(*) FROM IN_USE WHERE DATE BETWEEN '2007-05-01 12:00:00.0' AND '2007-05-04 15:00:00.0' AND KEYWORD_ID = 61517; SELECT COUNT(*) FROM IN_USE WHERE KEYWORD_ID = 61530; |