Those greps will find every line that does not contain "successfully" in your script and store them in suc_Logfile, and every line that does not contain "SQLSTATE" in the script, in fail_Logfile.
That doesn't sound like what you want.
If I can assume $output is what you want to look over, try this for the grep portion:
Hi all
I would like to open a SQL session from within a shell script and then redirect the output of the SQL command to a file.
e.g.
#!/bin/bash
sqlplus "/ as sysdba" <<EOF
@$HOME/recovery_space.sql
EOF
I want to redirect the output of the SQL command to a temp file, because... (2 Replies)
Hi ,
I just found you while surfing for the string
'Redirecting sql select query output from within a shell script to txt file/excel file'
Could you find time sending me the code for the above question?
It'll be great help for me.
I have a perl file that calls the sql file... (1 Reply)
Hi Yogesh,
Lucky that i caught you online. Yeah i read about DBI and the WriteExcel module. But the server is not supporting these modules. It said..."Cannot locate DBI"..."Cannot locate Spreadsheet::WriteExcel"
I tried creating a simple text file to get the query output, but the... (1 Reply)
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Hello Guys,
This message is somewhat relates with last thread. But I need to re-write thing. I start over a little. I am stuck now and need your help.
Here is my script-
#! /bin/ksh
export ORACLE_HOME=/opt/oracle/app/oracle/product/9.2
/opt/oracle/app/oracle/product/9.2/bin/sqlplus -s... (5 Replies)
Hi
I want ot save SQL query result in one txt file. for that i have written one code line
sqlplus -s $dbstring @/usr/local/bin/sched/nightly_Cronjob/exec_123.sql >> /usr/local/bin/sched/nightly_Cronjob/result.txt
but it is not working .
database : Oracle
so please advice me how can i... (7 Replies)
In my korn shell - I have a sql with say 6 columns whose output i am redirecting to a file and attaching this file while sending a mail. While all this happens correctly, i face issues in the format of this file.
my intended output is
Column_1 Column_2 Column_3 Column_4 ... (7 Replies)
Hi,
I never did this before... what I want to do is execute a SQL query from a unix script and redirect sql query's output to a flat file (comma separated one) without the header info (no column names). I would also want not to print the query's output to the screen.
snapshot of my script:... (13 Replies)
Hi
I am trying to run sql query from solaris in csh script and send the output to email. Below is my sql query
select p.spid,se.program seprogram, se.machine, se.username, sq.sql_text,sq.retrows from v$process p
inner join v$session se on p.addr = se.paddr
inner join
( select... (2 Replies)
I am trying to write SQL query output into a .csv file. But in the output columns are displaying in different lines instead of coming in one line.
Main Code shell script:
this is my code:
#!/bin/bash
file="db_detail.txt"
. $file
rm /batch/corpplan/bin/dan.csv... (6 Replies)
Discussion started by: sandeepgoli53
6 Replies
LEARN ABOUT PHP
mysql_drop_db
MYSQL_DROP_DB(3) 1 MYSQL_DROP_DB(3)mysql_drop_db - Drop (delete) a MySQL databaseSYNOPSIS
Warning
This function was deprecated in PHP 4.3.0, and will be removed in the future, along with the entirety of the original MySQL exten-
sion. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more
information. Alternatives to this function include:
oExecute a
DROP DATABASE query
bool mysql_drop_db (string $database_name, [resource $link_identifier = NULL])
DESCRIPTION mysql_drop_db(3) attempts to drop (remove) an entire database from the server associated with the specified link identifier. This function
is deprecated, it is preferable to use mysql_query(3) to issue an sql DROP DATABASE statement instead.
o $database_name
- The name of the database that will be deleted.
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
Returns TRUE on success or FALSE on failure.
Example #1
mysql_drop_db(3) alternative example
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
$sql = 'DROP DATABASE my_db';
if (mysql_query($sql, $link)) {
echo "Database my_db was successfully dropped
";
} else {
echo 'Error dropping database: ' . mysql_error() . "
";
}
?>
Warning
This function will not be available if the MySQL extension was built against a MySQL 4.x client library.
Note
For backward compatibility, the following deprecated alias may be used: mysql_dropdb(3)mysql_query(3).
PHP Documentation Group MYSQL_DROP_DB(3)