[sqlite] load regexp noninteractive
Hello List, i use sqlite 3.6.22 Ubuntu 10.04 I want to use REGEXP in my queries but dont find a way to load the lib in noninteractive Mode. There is no -load Parameter for sqlite3 Binary. I tried to give 2 commands separated by ; in sql-query but this also dont works. All i want to do is to run a query on console like: /usr/bin/sqlite3 mydb.db "select * from a where field1 REGEXP '$foo';" What to do now? Thanks, Hajo ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] load regexp noninteractive
echo "select * from a where field1 REGEXP '$foo';" | /usr/bin/sqlite3 mydb.db /usr/bin/sqlite3 mydb.db <: > Hello List, > > i use sqlite 3.6.22 Ubuntu 10.04 > > I want to use REGEXP in my queries but dont find a way to load the lib in > noninteractive Mode. > There is no -load Parameter for sqlite3 Binary. I tried to give 2 commands > separated by ; in sql-query but this also dont works. > All i want to do is to run a query on console like: > /usr/bin/sqlite3 mydb.db "select * from a where field1 REGEXP '$foo';" > > What to do now? > > Thanks, > Hajo > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] load regexp noninteractive
Hello, thanks, 2nd is working. i do in perl now something like: $exe="/usr/bin/sqlite3 mydb.db <- Original Message - From: "Kit" To: "General Discussion of SQLite Database" Sent: Thursday, January 05, 2012 1:11 PM Subject: Re: [sqlite] load regexp noninteractive echo "select * from a where field1 REGEXP '$foo';" | /usr/bin/sqlite3 mydb.db /usr/bin/sqlite3 mydb.db <: Hello List, i use sqlite 3.6.22 Ubuntu 10.04 I want to use REGEXP in my queries but dont find a way to load the lib in noninteractive Mode. There is no -load Parameter for sqlite3 Binary. I tried to give 2 commands separated by ; in sql-query but this also dont works. All i want to do is to run a query on console like: /usr/bin/sqlite3 mydb.db "select * from a where field1 REGEXP '$foo';" What to do now? Thanks, Hajo ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] load regexp noninteractive
2012/1/5, Hajo Locke : > Hello, > thanks, 2nd is working. > i do in perl now something like: Next time write: "I want it for Perl". -- Kit ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] load regexp noninteractive
Next time write: "I want it for Perl". why? your answer would be the same if we talk about running a shellcommand? the scripting language which runs the call should be irrelevant... not? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] load regexp noninteractive
2012/1/5 Hajo Locke : > >> Next time write: "I want it for Perl". > > why? your answer would be the same if we talk about running a shellcommand? > the scripting language which runs the call should be irrelevant... > not? http://mailliststock.wordpress.com/2007/03/01/sqlite-examples-with-bash-perl-and-python/ -- Kit ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] load regexp noninteractive
http://mailliststock.wordpress.com/2007/03/01/sqlite-examples-with-bash-perl-and-python/ -- no, your example was best for me because DBI is not available in my case. the pure call by system() is what i need. i just needed the hint, not a full solution because this depends on conditions and goals... thanks again and bye, Hajo ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users