avalon-cvs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From froehl...@apache.org
Subject cvs commit: jakarta-avalon-cornerstone/apps/db/src/scripts/sql Test1.script
Date Mon, 17 Dec 2001 16:02:14 GMT
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:avalon-cvs-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:avalon-cvs-help@jakarta.apache.org>


Mime
View raw message