Re: [sqlite] Question on Sqlite DB

2006-11-07 Thread Benedetta . Turchi
Hi,

can SQLite receive as input a file containing SQL instructions?

Thank you 

Benedetta Turchi
Engineering Tools
Engineering Tools Website 




-
***
*** Symbian Software Ltd is a company registered in England and
Wales with registered number 4190020 and registered office at 2-6
Boundary Row, Southwark, London,  SE1 8HP, UK. This message is
intended only for use by the named addressee and may contain
privileged and/or confidential information. If you are not the
named addressee you should not disseminate, copy or take any action
in reliance on it. If you have received this message in error
please notify [EMAIL PROTECTED] and delete the message and any
attachments accompanying it immediately. Neither Symbian nor any of
its Affiliates accepts liability for any corruption, interception,
amendment, tampering or viruses occurring to this message in
transit or for any message sent by its employees which is not in
compliance with Symbian corporate policy. *
*


Re: [sqlite] Question on Sqlite DB

2006-11-07 Thread Dennis Cote

[EMAIL PROTECTED] wrote:


can SQLite receive as input a file containing SQL instructions?

  

Benedetta,

The SQLite library can't do that itself, but the command shell program 
that comes with it can using the .read command.


   sqlite3 mydb.db3 .read mysql.txt

This will open (or create) the database file and then execute all the 
SQL statements in the file mysql.txt.


HTH
Dennis Cote


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Question on Sqlite DB

2006-11-07 Thread John Stanton

Yes

[EMAIL PROTECTED] wrote:

Hi,




can SQLite receive as input a file containing SQL instructions?

Thank you 


Benedetta Turchi
Engineering Tools
Engineering Tools Website 





-
***
*** Symbian Software Ltd is a company registered in England and
Wales with registered number 4190020 and registered office at 2-6
Boundary Row, Southwark, London,  SE1 8HP, UK. This message is
intended only for use by the named addressee and may contain
privileged and/or confidential information. If you are not the
named addressee you should not disseminate, copy or take any action
in reliance on it. If you have received this message in error
please notify [EMAIL PROTECTED] and delete the message and any
attachments accompanying it immediately. Neither Symbian nor any of
its Affiliates accepts liability for any corruption, interception,
amendment, tampering or viruses occurring to this message in
transit or for any message sent by its employees which is not in
compliance with Symbian corporate policy. *
*




-
To unsubscribe, send email to [EMAIL PROTECTED]
-