Différences

Ci-dessous, les différences entre deux révisions de la page.

--- enseignement:dbdm:tp1 [2016/02/05 06:58]
ecoquery
+++ enseignement:dbdm:tp1 [2018/02/01 09:42] (Version actuelle)
rthion [SQLite practice]
@@ Ligne 1: / Ligne 1: @@
-====== SQL Lab: SQLite practice ======
+====== SQLite practice ======
-[[https://www.sqlite.org/index.html|SQLite]] is a widespread embedded SQL engine.
+[[https://www.sqlite.org/index.html|SQLite]] is a widespread embedded SQL engine. On your personal computer, one may appreciate [[http://sqlitebrowser.org/|SQLiteBrowser]] which provides a user friendly GUI on top of SQLite.
 This lab will give you some practice on SQL querying.
@@ Ligne 20: / Ligne 20: @@
 As SQLite is not a full featured DBMS server, starting the SQLite shell on a database file is sufficient to get started.
-In a working directory of your choice, download {{:enseignement:dbdm:tp1-dbdm.sql|}}, then start SQLite((this create the ''movies.db'' file if it doesn't exists already)):
+In a working directory of your choice, download {{:enseignement:dbdm:tp1-dbdm.sql|}}, then start SQLite((this creates the ''movies.db'' file if it doesn't exists already)):
 <code sh>
 sqlite3 movies.db
 </code>
 Execute the sql script:
-<code sql>
+<code>
-.read TP1-DBDM.sql
+.read tp1-dbdm.sql
 </code>
-And turn on headers for getting attributes on results
+And turn on headers and column mode for getting attributes on results and human friendly format
 <code>
 .headers on
+.mode column
 </code>

Emmanuel COQUERY