froehlich 01/12/17 08:12:04
Modified: apps/db/src/scripts/sql Test1.script
Log:
create, insert, select + criteria is working 90%
Revision Changes Path
1.5 +5 -5
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.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- Test1.script 2001/12/17 16:02:14 1.4
+++ Test1.script 2001/12/17 16:12:04 1.5
@@ -1,16 +1,16 @@
### CREATE ##!
CREATE TABLE Primes
- ( prime INTEGER NOT NULL,
- sequence INTEGER NOT NULL,
- words VARCHAR(50) 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 prime, sequence FROM Primes where prime = 2
+SELECT priMe, seQuence FROM Primes where prime = 2
###
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
