MYSQL_FIND_ROWS MySQL Database System MYSQL_FIND_ROWS
NAME
mysql_find_rows - extract SQL statements from files
SYNOPSIS
mysql_find_rows [options] [file_name ...]
DESCRIPTION
mysql_find_rows reads files containing SQL statements and extracts statements that match a given regular expression or that contain USE
db_name or SET statements. The utility expects statements to be terminated with semicolon (;) characters.
Invoke mysql_find_rows like this:
shell> mysql_find_rows [options] [file_name ...]
Each file_name argument should be the name of file containing SQL statements. If no file names are given, mysql_find_rows reads the
standard input.
Examples:
mysql_find_rows --regexp=problem_table --rows=20 < update.log
mysql_find_rows --regexp=problem_table update-log.1 update-log.2
mysql_find_rows supports the following options:
o --help, --Information
Display a help message and exit.
o --regexp=pattern
Display queries that match the pattern.
o --rows=N
Quit after displaying N queries.
o --skip-use-db
Do not include USE db_name statements in the output.
o --start_row=N
Start output from this row.
COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
MySQL 5.5 01/30/2014 MYSQL_FIND_ROWS
Check Out this Related Man Page
MYSQLBUG(1) MySQL Database System MYSQLBUG(1)NAME
mysqlbug - generate bug report
SYNOPSIS
mysqlbug
DESCRIPTION
This program is obsolete.
The normal way to report bugs is to visit http://bugs.mysql.com/, which is the address for our bugs database. This database is public and
can be browsed and searched by anyone. If you log in to the system, you can enter new reports.
COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
MySQL 5.5 01/30/2014 MYSQLBUG(1)
Hi all, I'm confused about the proper syntax for multi-conditional if then statements. I'm trying to set limitations on info input on the command line.. i.e.
if ] ;then
$x=$vr1
else
print "You have entered an invalid option."
Can someone please clue me in on what is wrong with my syntax;... (3 Replies)
Hi,
I am using few ISQL statements to update and delete from a few tables in sybase, now i want to roll back the transaction when any of the statements fail.How i can i capture these errors in the shell scripts.Please advise.
Thanks,
Gopi (4 Replies)
Hi,
Can someone let me know how I can acheive the following.
I have ~ delimited file and I need to convert into something like SQL insert statements.
SrcFile :
1~sjdsdj~asasas~
2~aaaaa~qwqwqwq~qwq
.....
I tried
AWK -F"~" '{print "INSERT INTO XX VALUES("$1 " ,\' "$2" \' , \' "$3 }'... (3 Replies)
Hello-
The code below works fine expect that it does not update the table CTL_INTERFACE "red highlight". Any idea what I'm doing wrong here?
Thanks:D
# coNNECT to the database and insert a row then get the new row id
cycle_id=`sqlplus -S $XXX_USER/$XXX_PW@$XXX_CONNECT << EOF
SET ECHO... (3 Replies)
Hi All
I have a requirement to copy a file from one location to other and at the end the file copying is over it will update a oracle table with below details.
file_name
file_creation_time
copy_start_datetime
copy_end_datetime
rec_count
please help me writing this script (12 Replies)
Dear Community,
I tried for over 4 days to figur this out.
I got a Shell-Code which contains some If-statements which are driving me crazy.
First of all the statements:
err=0;
echo "If-Test begins..."
if ! ];then
echo "If NOT 0"
fi
if ];then
echo "If NOT (inside braces) 0"
fi
... (3 Replies)
Hi,
I have an input file which have many lines,from which i need to extract only the complete sql statements and write this alone to an output file.
please help us in this.
Regards
Meva (7 Replies)
I know I know..
for sure one of the easier mysql statements. But somehow I can not figure out this.
I expect to see all distinct items of 'data_12' where 'kwroot' has 'straxx' in, and in the same row 'data_12' ist (not = 'kwsearched' in any existing row)
data_12 ... (6 Replies)
Hi,
I am trying to write a generic script as a part of a framework which will establish Oracle DB connection once and loops in to check for some files which gives the SQL statements to execute.
The script is running but I am stuck with capturing errors ( ORA and SP) and outputs. Example:
... (4 Replies)
Dear Unix community over the last couple of days I have been working on learning Unix scripting on iOS using terminal on a jail-broken device...
I am having trouble with if statements and giving the user a y or n choice that do different things when entered. The following is my code so far...... (5 Replies)
I have the following bash code, and wondering if it is possible (and a good idea) to write the if statements in one line.
# Run raytrac on the sound speed model.
if ; then
$bashPath/raytrac.bash -fcmd=$fcmd.cmd
fi
# Plot the travel times and ray paths.
if ; then
... (8 Replies)
Hi
My requirement is as follows.
In a particular source directory say /home/Source, I need to search for filename with the following pattern.
Bank_YYYYMMDD.txt
and if the files with patterns are found them move them to archive directory /home/Source/Archive.
The script should not do... (8 Replies)
Hi everyone!
I'm having difficulties setting up a complex script with nested if statements while doing some word extracts, any help is appreciated.
Scenario:
1- Check if the file.txt has the word BINGO
2- If so then get the available number (any number) in the line that contains the word... (8 Replies)
Dear all,
I would like to use SQL's log file to extract information from it.
This file can include four different types of instruction with the number of lines involved for each of them:
-> (1) "INSERT" instruction with the number of lines inserted
-> (2) "UPDATE" instruction with the... (4 Replies)