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 "
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