RE: [LIH] Submit a query for MySQL from Linux shell prompt

[Unix-Contractor, Wipro (CORP)]

MySQL you have to create a .sql file with the sql statements in that later
you can run this as 

$mysql -u <user name> -p<password> <DATA BASE> << filename

Mohan

-----Original Message-----
From: Binand Raj S. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 04, 2000 9:07 AM
To: [EMAIL PROTECTED]
Subject: Re: [LIH] Submit a query for MySQL from Linux shell prompt


Linux Fan forced the electrons to say:
> Is it possible to submit/execute queries to the MySQL
> server right from the Linux shell prompt.. ie. without
> going to the mysql> prompt????

Postgres has the -c option to psql, ie, like:

$ psql -c 'select * from tablename' databasename

I am sure mysql will also have something similar.

Binand

-- 
The prompt for all occasions:
export PS1="F:\$(pwd | tr '/[a-z]' '\134\134[A-Z]')> "
--------------- Binand Raj S. ([EMAIL PROTECTED])


-----------------------------------------------------------------------
For more information on the LIH mailing list see:
http://lists.linux-india.org/lists/LIH

-----------------------------------------------------------------------
For more information on the LIH mailing list see:
http://lists.linux-india.org/lists/LIH