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 ----- Mail original ----- 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