*** 51,63 **** *: 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 - _SQLite used to have this but it was removed because it is not standard SQL._ *RETURN IT BACK AGAIN, PLEASE!!!* *: name columns in views (i.e. CREATE VIEW (foo, bar) AS SELECT qux, quo FROM baz;) --- 51,60 ---- *: 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 *: 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) *: join syntax (+) (-) like oracle has - _SQLite used to have this but it was removed because it is not standard SQL._ *RETURN IT BACK AGAIN, PLEASE!!!* *: name columns in views (i.e. CREATE VIEW (foo, bar) AS SELECT qux, quo FROM baz;)