A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Linux / UNIX
database access in shell script
Joined: Nov 25, 2007
May 25, 2008 23:51:00
Can I access data base in shell script?
Joined: Jun 25, 2001
May 26, 2008 06:23:00
You certainly can. Almost all DBMS's have some sort of command-line utility and many of them are even powerfule enough to generate reports, HTML pages and even XML.
For the PostgreSQL DBMS, the basic command-line tool is "psql". For MySQL, it's "mysql". For Oracle, it's "sqlplus". I forget what DB2 uses.
For SQL Server, the command line tool is iSql, but of course, you have to be running a Windows client in order to use it. Microsoft lives in their own little world.
Customer surveys are for companies who didn't pay proper attention to begin with.
It is sorta covered in the
JavaRanch Style Guide
subject: database access in shell script
read large CSV file and update the database
How can I apply a XSL to the result of another XSL?
what shell is this
Running Unix commands thru Java
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014