Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

mysql_find_rows(1) [linux man page]

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)
Man Page

15 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

multiple conditions in if statements

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)
Discussion started by: tim mauger
3 Replies

2. UNIX for Advanced & Expert Users

Error Handling in Korn Shell scripts

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)
Discussion started by: bhgopi
4 Replies

3. Shell Programming and Scripting

Whats the meaning

What the folowing statements means and whats the use of it ? expr $db_name + 2 >/dev/null 2>&1 Thanks. (7 Replies)
Discussion started by: dhananjaysk
7 Replies

4. Shell Programming and Scripting

AWK handling of single quote

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)
Discussion started by: braindrain
3 Replies

5. UNIX for Advanced & Expert Users

SQLPLUS and update statements using bind variables

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)
Discussion started by: Nomaad
3 Replies

6. Shell Programming and Scripting

Help in scripting

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)
Discussion started by: dr46014
12 Replies

7. Shell Programming and Scripting

IF-Statements not working

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)
Discussion started by: Henry_Ford
3 Replies

8. Shell Programming and Scripting

How to extract queries using UNIX shell script?

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)
Discussion started by: meva
7 Replies

9. Shell Programming and Scripting

SQL select all but not if it is already in an other column

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)
Discussion started by: lowmaster
6 Replies

10. UNIX for Advanced & Expert Users

Extract Oracle DB Connect and SQL execution log

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)
Discussion started by: mirage0809
4 Replies

11. UNIX for Dummies Questions & Answers

If statements/general help

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)
Discussion started by: mbf123
5 Replies

12. Shell Programming and Scripting

Bash if statements in one line

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)
Discussion started by: kristinu
8 Replies

13. UNIX for Dummies Questions & Answers

UNIX script to find existences of files with a pattern in name

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)
Discussion started by: b.joe
8 Replies

14. Shell Programming and Scripting

Nested if statements with word/number extracts

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)
Discussion started by: demmel
8 Replies

15. Shell Programming and Scripting

Parsing a log file to cut off some parts

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)
Discussion started by: dae
4 Replies