I am considering switching over to SQLite from MySQL. Before I take the
plunge, could someone give me the heads up on whether any of the following
commands are applicable in SQLite? (I couldn't tell from the documentation):
1. REPAIR TABLE tableName EXTENDED
2. SELECT DATE_FORMAT(dateColumn, '%m/%d/%y') FROM theTable WHERE dateColumn
BETWEEN SUBDATE(CURDATE(), INTERVAL 1 DAY) AND CURDATE()
3. SELECT t1.rowID, t2.rowID FROM tableName1 AS t1, tableName2 AS t2 WHERE
t1.theColumn = t2.theColumn AND LENGTH(t1.theColumn) = LENGTH(t2.theColumn)
AND t1.rowID > t2.rowID
4. SELECT COUNT(*) FROM theTable WHERE someColumn = 'someString'
5. OPTIMIZE TABLE theTable
6. SELECT DISTINCT(theColumn) FROM theTable
7. INSERT IGNORE INTO theTable VALUES ('someString', NULL)
8. UNLOCK TABLES
9. LOCK TABLES theTable READ
10. SELECT rowID, anotherColumn INTO OUTFILE path/to/file FROM theTable
11. LOAD DATA INFILE path/to/file INTO TABLE theTable
12. INSERT theTable (oneColumn, anotherColumn) SELECT oneColumn,
anotherColumn FROM theTable WHERE rowID = 5
Any info would be much appreciated!
Thanks,
John
