[sqlite] DATEADD?

[Jake Skinner]

This is a MySQL function, is there an equivalent?

I couldn't find anything that resembles it. I expect that it is a MySQL 
specific thing but I thought I would ask people to be sure.

Thanks
Jake
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Querying 2 databases

[Derrell . Lipman]

Bronislav Klučka <[EMAIL PROTECTED]> writes:

> Hi,
> I've already asked this question, but nobody answered...
> Is there any way how to ask 2 databases??
> "select db1.table1.id,db2.table9.name from db1.table1 left join db2.table9
> on db1.table1.id=db2.table9.id_object"

See the documentation for the SQLite-specific command ATTACH.  Tha
should do what you're looking for.

Derrell

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Querying 2 databases

[D. Richard Hipp]

Bronislav Klučka wrote:
Hi,
I've already asked this question, but nobody answered...
Is there any way how to ask 2 databases??
"select db1.table1.id,db2.table9.name from db1.table1 left join db2.table9
on db1.table1.id=db2.table9.id_object"

http://www.sqlite.org/lang.html#attach

--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Querying 2 databases

[Bronislav Klučka]

Hi,
I've already asked this question, but nobody answered...
Is there any way how to ask 2 databases??
"select db1.table1.id,db2.table9.name from db1.table1 left join db2.table9
on db1.table1.id=db2.table9.id_object"


Brona


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]