froehlich 01/12/17 08:02:14
Modified: apps/db/src/scripts/sql Test1.script
Log:
create, insert, select + criteria is working 90%
Revision Changes Path
1.4 +4 -8
jakarta-avalon-cornerstone/apps/db/src/scripts/sql/Test1.script
Index: Test1.script
===================================================================
RCS file:
/home/cvs/jakarta-avalon-cornerstone/apps/db/src/scripts/sql/Test1.script,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- Test1.script 2001/12/16 13:01:09 1.3
+++ Test1.script 2001/12/17 16:02:14 1.4
@@ -1,20 +1,16 @@
### CREATE ##!
CREATE TABLE Primes
- ( prime INT NOT NULL,
- sequence INT NOT NULL,
+ ( prime INTEGER NOT NULL,
+ sequence INTEGER NOT NULL,
words VARCHAR(50) NOT NULL )
### INSERT ##!
-INSERT INTO PRIMES (prime, sequence, words) VALUES (2,1,'two')
+INSERT INTO Primes (prime, sequence, words) VALUES (2,1,'two')
-###
-
### SELE 1 ##!
-SELECT forename, surname FROM Flintstones where foranme='dd' and
surname='dd' and(dd='dsds' or dd='22'))
+SELECT prime, sequence FROM Primes where prime = 2
###
-
-
\ No newline at end of file
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
