X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fcsql.xml;h=f84dd50691c54b8e748cd2f1ef344caeda7d9df8;hb=fe5d3a2b2a94e72fa7774d6b348f853127565699;hp=814b7f4188f848a02a262120e02fc18e19e99296;hpb=2949884623a44f1866a383fb74a88aada9fced93;p=clsql.git diff --git a/doc/csql.xml b/doc/csql.xml index 814b7f4..f84dd50 100644 --- a/doc/csql.xml +++ b/doc/csql.xml @@ -83,7 +83,7 @@ + url="http://philip.greenspun.com/sql/data-modeling.html"> Philip Greenspun's "SQL For Web Nerds" - Data Modeling @@ -250,7 +250,7 @@ mapped into a database). They would be defined as follows: - :column- - A string which will be used as the + :db-type - A string which will be used as the type specifier for this slots column definition in the database. @@ -300,7 +300,7 @@ mapped into a database). They would be defined as follows: In an &sql; only application, the EMPLOYEE and COMPANY tables can be queried to determine things -like, "Who is Vladamir's manager?", "What company does Josef work +like, "Who is Vladimir's manager?", "What company does Josef work for?", and "What employees work for Widgets Inc.". This is done by joining tables with an &sql; query. @@ -316,12 +316,12 @@ SELECT first_name, last_name FROM employee, company -Who is Vladamir's manager? +Who is Vladimir's manager? SELECT managerid FROM employee - WHERE employee.first_name = "Vladamir" + WHERE employee.first_name = "Vladimir" AND employee.last_name = "Lenin" @@ -489,7 +489,7 @@ any other CLOS object: (defvar employee1 (make-instance 'employee :emplid 1 - :first-name "Vladamir" + :first-name "Vladimir" :last-name "Lenin" :email "lenin@soviet.org" :companyid 1))