Re: [sqlite] SQL Commands Again

2004-08-02 Thread John Dean
, 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 > documentat

Re: [sqlite] SQL Commands Again

2004-08-01 Thread Gerard Samuel
On Sunday 01 August 2004 11:02 pm, John Mistler wrote: > 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 f

RE: [sqlite] SQL Commands Again

2004-08-01 Thread Dong Xuezhang-A19583
] 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 (

[sqlite] SQL Commands Again

2004-08-01 Thread John Mistler
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

[sqlite] SQL commands

2004-07-29 Thread John Mistler
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