*** 17,22 ****
--- 17,27 ----
do sqlite_open(). To drop a database, delete the file._
*: ALTER VIEW, ALTER TRIGGER, ALTER TABLE
*: Schemas - _Who can tell me what this means?_
+ _::: The idea is that multiple users using the same database can cleanly
+ separate their tables, views (stored procs, etc) by prefixing them with
+ their login, so jack's jack.importantTable is distinct from jill's jill.importantTable. There are administrative benefits ('Jack left and
+ we don't like his work; can we kill everything he did?' Ans: 'Yes, let me just
+ drop his schema..', with aliases, jill.importantTable can be made available to everybody as 'importantTable', permissions can be hung off schemas). The common notation (jill.importantTable) would map to databasename.tablename in the current sqlite arrangement.
*: TRUNCATE (MySQL, Postgresql and Oracle have it... but I dont know if this is a standard command) - _SQLite does this automatically when you do a DELETE
without a WHERE clause._
*: ORDER BY myfield ASC NULLS LAST (Oracle)
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|