Hi,

To not use
a password on the command line it is necessary to use an external file. 
You can find example on this page: http://wiki.openstreetmap.org/wiki/MonetDB#Connecting_to_the_Database
Martin: Man monetd lack of examples


You can then run
mclient -d base script.sql


Pierre

--
1G6
52 route de bischwiller
67300 Schiltigheim

Société de Services et de Formations en Logiciels Libres
http://1g6.biz
Tél : 06 64 63 70 35



De: "Martin Kersten" <Martin.Kersten@cwi.nl>
À: users-list@monetdb.org
Envoyé: Lundi 3 Novembre 2014 06:27:17
Objet: Re: Querying from Linux Terminal

On 03/11/14 06:24, Vijay Krishna wrote:
> Hi,
>
> Can I execute a large number of queries through shell script directly from terminal?
>
read the manual
https://www.monetdb.org/Documentation/mclient-man-page
> In MySql I use, mysql -u root -ppassword -e "select * from table"  in my shell script, which returns the result without logging into mysql client. Similarly, I want to execute queries in the terminal without logging into mclient.
>
> Is there any equivalent way of achieving the same? I have to do a lot of updates and instead of doing those one by one, I prefer writing a shell script to run hundreds of queries one by one automatically.
>
read data loading:
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/LoadingBulkData
> Any help much appreciated.
>
> With Regards,
>
> Vijayakrishna.P.
> Mobile : (+91) 9500402305.
>
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list