|
|
STRUCTURE DE LA BASE bmscombourg :
- bapteme(IDBAPTEME, Dateb, Nom, Prenom1, Prenom2, Prenom3, Sexe, Nompere, Prenompere, Profpere, Nommere, Prenommere, Nomparrain, Prenomparrain, Profparrain, Nommarraine, Prenommarraine, Legitime, Jumeau, )
- deces(IDDECES, Dated, Nom, Prenom, Sexe, Age, Classeage, Qualite, Nom1, Prenom1, Nom2, Prenom2, Profession, Enterre, Lieudeces, )
- mariage(IDMARIAGE, Datem, Nommari, Prenommari, Profmari, Nomperemari, Prenomperemari, Nommeremari, Prenommeremari, Signmari, Nomfemme, Prenomfemme, Nomperefemme, Prenomperefemme, Nommerefemme, Prenommerefemme, Signfemme, )
PRINCIPAUX MOTS CLEFS SQL :
- SELECT, DISTINCT, AS, FROM, JOIN, LEFT JOIN, ON
- WHERE, IN, BETWEEN, LIKE, AND, OR, NOT, IS NULL, IS NOT NULL
- ORDER BY, DESC
- SUM(), AVG(), MAX(), COUNT(), COUNT(DISTINCT )
- GROUP BY, HAVING, UNION, SOME, ALL
|