You really should read the excellent documentation. All will be revealed therein
Regards
John Dean
co-author of Rekall,
the alternative to MS Access
----- Original Message -----
From: "John Mistler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 02, 2004 4:02 AM
Subject: [sqlite] SQL Commands Again
> I posted this a few days ago and didn't get any responses. I thought I
> would try once more. My question is whether any of these queries will work
> in sqlite, as I have used them in MySQL. I can't tell from the
> documentation. Thanks for any help (if on even just a few of them) --
>
> 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
>
> Thanks,
>
> John
>
>
>
