Re: [sqlite] Question on Sqlite DB
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
[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
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] -