On Thu, Jun 24, 2010 at 9:19 AM, Eric Smith wrote:
> Peng Yu wrote:
>
>> On Thu, Jun 24, 2010 at 5:05 AM, Simon Slavin wrote:
>> >
>> > On 24 Jun 2010, at 4:50am, Peng Yu wrote:
>> >
>> >> Is there a way to use Shebang for sqlite3 script?
>> >>
>> >>
On Thu, Jun 24, 2010 at 10:36:20AM -0400, Pavel Ivanov scratched on the wall:
> > I was asking whether it is possible to use Shebang with sqlite script.
> > If it is possible, would you please show me how to modify the
> > following script to do so?
>
> If you don't mind one error message then
On 24 Jun 2010, at 3:13pm, Peng Yu wrote:
> I was asking whether it is possible to use Shebang with sqlite script.
> If it is possible, would you please show me how to modify the
> following script to do so?
>
> $ ./main.sql
> Error: unknown command or invalid arguments: "/main.sql". Enter
>
> I was asking whether it is possible to use Shebang with sqlite script.
> If it is possible, would you please show me how to modify the
> following script to do so?
If you don't mind one error message then you can do it like this:
> cat test.sql
#!/usr/bin/sqlite3 -init
;
create table tbl1(one
On Thu, Jun 24, 2010 at 09:13:01AM -0500, Peng Yu scratched on the wall:
> I was asking whether it is possible to use Shebang with sqlite script.
> If it is possible, would you please show me how to modify the
> following script to do so?
Not possible. Shebang assumes the input file can be
Peng Yu wrote:
> On Thu, Jun 24, 2010 at 5:05 AM, Simon Slavin wrote:
> >
> > On 24 Jun 2010, at 4:50am, Peng Yu wrote:
> >
> >> Is there a way to use Shebang for sqlite3 script?
> >>
> >> http://en.wikipedia.org/wiki/Shebang_%28Unix%29
> >
> > SQLite comes with a
On Thu, Jun 24, 2010 at 5:05 AM, Simon Slavin wrote:
>
> On 24 Jun 2010, at 4:50am, Peng Yu wrote:
>
>> Is there a way to use Shebang for sqlite3 script?
>>
>> http://en.wikipedia.org/wiki/Shebang_%28Unix%29
>
> SQLite comes with a command-line tool. You can feed it with
On 24 Jun 2010, at 4:50am, Peng Yu wrote:
> Is there a way to use Shebang for sqlite3 script?
>
> http://en.wikipedia.org/wiki/Shebang_%28Unix%29
SQLite comes with a command-line tool. You can feed it with individual
commands on a Unix command-line or tell it to read commands from a file.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/23/2010 08:50 PM, Peng Yu wrote:
> Is there a way to use Shebang for sqlite3 script?
What happened when you tried it?
Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla -
On Tue, May 25, 2010 at 3:25 PM, Black, Michael (IS)
wrote:
> sqlite3 main.db < main.txt
>
> or
> cat main.txt | sqlite3 main.db
>
> or
>
> echo "create table tbl1(one varchar(10), two smallint);" | sqlite3 main.db
Is there a way to use Shebang for sqlite3 script?
..@sqlite.org on behalf of Peng Yu
Sent: Tue 5/25/2010 9:20 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] How accept sqlite3 commands from stdin
I got the following error when I try to read the commands from the
command line. Would you please let me know how to let sqlite3 read
from stdin?
$ cat ma
I got the following error when I try to read the commands from the
command line. Would you please let me know how to let sqlite3 read
from stdin?
$ cat main.txt
create table tbl1(one varchar(10), two smallint);
$ echo main.txt |sqlite3 main.db
Incomplete SQL: main.txt
--
Regards,
Peng
12 matches
Mail list logo