Page History
- 2007-Dec-30 10:13 anonymous
- 2007-Dec-03 15:17 anonymous
- 2007-Nov-13 09:23 anonymous
- 2007-Aug-23 20:32 anonymous
- 2007-Aug-07 23:18 anonymous
- 2007-Jul-24 05:05 anonymous
- 2007-Jun-22 15:27 anonymous
- 2007-Jun-22 15:01 anonymous
- 2007-Jun-22 14:43 anonymous
- 2007-Jan-10 14:36 anonymous
- 2006-Dec-20 03:19 anonymous
- 2006-Oct-28 18:13 anonymous
- 2006-Oct-07 17:30 anonymous
- 2006-Oct-07 17:27 anonymous
- 2006-Sep-15 13:51 anonymous
- 2006-Aug-29 08:58 anonymous
- 2006-Jul-24 01:25 anonymous
- 2006-Jul-24 01:22 anonymous
- 2006-Jul-24 01:18 anonymous
- 2006-May-19 09:19 anonymous
- 2006-May-01 16:16 anonymous
- 2006-Apr-28 17:57 anonymous
- 2006-Apr-27 22:08 anonymous
- 2006-Apr-18 12:36 anonymous
- 2006-Apr-12 17:41 anonymous
- 2006-Apr-12 09:50 anonymous
- 2006-Apr-07 16:56 anonymous
- 2006-Apr-04 16:30 anonymous
- 2006-Apr-04 10:28 anonymous
- 2006-Apr-02 10:57 anonymous
- 2006-Apr-01 07:45 anonymous
- 2006-Apr-01 07:41 anonymous
- 2006-Mar-28 16:46 anonymous
- 2006-Mar-28 16:32 anonymous
- 2006-Mar-27 17:50 anonymous
- 2006-Mar-20 18:05 anonymous
- 2006-Mar-20 17:57 anonymous
- 2006-Mar-20 17:53 anonymous
- 2006-Mar-20 14:24 anonymous
- 2006-Mar-20 12:12 anonymous
- 2006-Mar-19 21:48 anonymous
- 2006-Mar-19 21:27 anonymous
- 2006-Mar-19 21:20 anonymous
- 2006-Mar-19 21:13 anonymous
- 2006-Mar-19 21:12 anonymous
- 2006-Mar-19 21:08 anonymous
- 2006-Mar-19 21:06 anonymous
- 2006-Mar-19 21:04 anonymous
- 2006-Mar-19 20:58 anonymous
- 2006-Mar-19 20:54 anonymous
- 2006-Mar-19 20:53 anonymous
- 2006-Mar-19 20:49 anonymous
- 2006-Mar-19 20:41 anonymous
- 2006-Mar-19 20:33 anonymous
- 2006-Mar-19 20:31 anonymous
- 2006-Mar-19 20:12 anonymous
- 2006-Mar-06 16:12 anonymous
- 2006-Mar-06 16:11 anonymous
- 2006-Mar-06 01:27 anonymous
- 2006-Feb-21 05:24 anonymous
- 2006-Feb-20 17:35 anonymous
- 2006-Feb-19 10:33 anonymous
- 2006-Feb-17 23:11 anonymous
- 2006-Feb-16 22:49 anonymous
- 2006-Feb-15 16:05 anonymous
- 2006-Feb-15 10:38 anonymous
- 2006-Feb-15 01:13 anonymous
- 2006-Feb-04 15:18 anonymous
- 2006-Jan-24 21:52 anonymous
- 2006-Jan-20 13:02 anonymous
- 2006-Jan-20 12:38 anonymous
- 2006-Jan-20 12:32 anonymous
- 2006-Jan-19 22:20 anonymous
- 2006-Jan-19 22:19 anonymous
- 2006-Jan-19 04:05 anonymous
- 2006-Jan-14 21:56 anonymous
- 2006-Jan-02 13:38 anonymous
- 2005-Dec-27 16:15 anonymous
- 2005-Dec-17 23:29 anonymous
- 2005-Nov-21 11:17 anonymous
- 2005-Oct-19 05:14 anonymous
- 2005-Oct-06 20:49 anonymous
- 2005-Oct-06 20:19 anonymous
- 2005-Oct-04 07:06 anonymous
- 2005-Oct-02 02:51 anonymous
- 2005-Sep-30 16:56 anonymous
- 2005-Sep-25 07:17 anonymous
- 2005-Sep-21 18:28 anonymous
- 2005-Sep-21 18:24 anonymous
- 2005-Sep-21 14:58 anonymous
- 2005-Sep-21 00:29 anonymous
- 2005-Sep-06 16:36 drh
- 2005-Sep-06 13:52 anonymous
- 2005-Aug-29 17:22 drh
- 2005-Aug-29 16:30 anonymous
- 2005-Aug-25 03:31 anonymous
- 2005-Aug-18 09:09 anonymous
- 2005-Aug-13 01:43 anonymous
- 2005-Aug-12 11:41 anonymous
- 2005-Aug-09 12:41 anonymous
- 2005-Aug-09 12:18 anonymous
- 2005-Aug-03 21:43 anonymous
- 2005-Jun-01 02:32 anonymous
- 2005-May-26 02:08 anonymous
- 2005-Apr-27 19:04 anonymous
- 2005-Apr-19 22:02 anonymous
- 2005-Apr-11 17:41 anonymous
- 2005-Apr-11 13:24 anonymous
- 2005-Apr-08 20:43 anonymous
- 2005-Apr-08 19:29 anonymous
- 2005-Mar-06 12:01 anonymous
- 2005-Feb-28 21:36 anonymous
- 2005-Feb-27 11:37 anonymous
- 2005-Feb-04 03:28 anonymous
- 2005-Jan-22 22:09 anonymous
- 2005-Jan-22 11:53 anonymous
- 2005-Jan-16 10:39 anonymous
- 2005-Jan-16 08:04 anonymous
- 2004-Nov-23 04:51 anonymous
- 2004-Nov-17 19:51 anonymous
- 2004-Oct-27 16:00 anonymous
- 2004-Oct-26 18:39 anonymous
- 2004-Oct-21 16:53 anonymous
- 2004-Oct-03 22:24 anonymous
- 2004-Oct-03 12:57 anonymous
- 2004-Sep-02 18:06 anonymous
- 2004-Aug-29 14:26 anonymous
- 2004-Jul-29 15:22 anonymous
- 2004-Jul-20 14:59 anonymous
- 2004-Jun-26 14:46 anonymous
- 2004-Jun-09 18:43 anonymous
- 2004-May-11 13:31 anonymous
- 2004-May-06 09:32 anonymous
- 2004-May-06 01:37 anonymous
- 2004-May-05 22:17 anonymous
- 2004-Apr-25 16:34 anonymous
- 2004-Apr-25 15:26 anonymous
- 2004-Apr-16 09:19 anonymous
- 2004-Apr-10 19:03 dougcurrie
- 2004-Apr-10 12:33 anonymous
- 2004-Apr-08 00:22 anonymous
- 2004-Apr-07 19:56 anonymous
- 2004-Apr-07 19:53 anonymous
- 2004-Apr-03 16:28 anonymous
- 2004-Mar-26 07:00 anonymous
- 2004-Mar-18 03:55 anonymous
- 2004-Mar-18 01:10 anonymous
- 2004-Mar-17 21:33 anonymous
- 2004-Mar-09 14:45 anonymous
- 2004-Mar-07 00:44 anonymous
- 2004-Feb-28 14:40 drh
- 2004-Feb-25 19:44 anonymous
- 2004-Feb-18 11:13 anonymous
- 2004-Feb-16 14:00 anonymous
- 2004-Jan-29 23:40 anonymous
- 2004-Jan-22 23:40 drh
- 2004-Jan-22 21:39 anonymous
- 2004-Jan-08 22:10 anonymous
- 2004-Jan-01 00:41 anonymous
- 2003-Dec-18 06:01 anonymous
- 2003-Nov-19 05:11 anonymous
- 2003-Nov-19 05:09 anonymous
- 2003-Oct-30 15:09 anonymous
- 2003-Sep-04 17:18 anonymous
- 2003-Aug-29 15:45 anonymous
- 2003-Aug-06 00:18 anonymous
- 2003-Aug-06 00:13 anonymous
- 2003-Aug-05 21:39 anonymous
- 2003-Jul-28 03:20 anonymous
- 2003-Jul-28 03:18 anonymous
- 2003-Jul-02 10:09 anonymous
- 2003-Jul-02 07:34 anonymous
- 2003-Jun-30 10:33 drh
- SQL92 Character sets, collations, coercibility.
- Inserting blob using X'AABBCCDD' syntax.
- Stored Procedures
- Rollup and Cube
- INSERT INTO with multiple rows (ie. INSERT INTO table VALUES (...), (...). etc)
- CREATE DATABASE, DROP DATABASE
- ALTER VIEW, ALTER TRIGGER, ALTER TABLE
- Schemas
- TRUNCATE (MySQL, Postgresql and Oracle have it... but I dont know if this is a standard command)
- ORDER BY myfield ASC NULLS LAST (Oracle)
- CREATE TRIGGER [BEFORE | AFTER | INSTEAD OF] (Oracle)
- UPDATE with a FROM clause (not sure if this is standard, Sybase and Microsoft have it).
- Multi-column IN clause (ie. SELECT * FROM tab WHERE (key1, key2) IN (SELECT...)
- CURRENT-Functions like CURRENT_DATE, CURRENT_TIME are missing
- INSERTing less values than columns does not fill the missing columns with the default values; if less values than columns in the table are supplied, all columns filled have to be named before the keyword values
- rename table command (mysql has)
- ESCAPE clause for LIKE
- DISTINCT ON (expr,...) - this is from Postgres, where expr,... must be the leftmost expressions from the ORDER BY clause
- MEDIAN and standard deviation... are they standard? Useful for sqlite standalone (for shell script users)
- enum column type (mysql does)
- join syntax (+) (-) like oracle has
- name columns in views (i.e. CREATE VIEW (foo, bar) AS SELECT qux, quo FROM baz;)