- Documentation Library
- Table of Contents
- MySQL 5.5 Manual
- MySQL 5.4 Manual
- MySQL 5.1 Manual
- MySQL 5.0 Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- 4.6 MySQL Administrative and Utility Programs
- 4.6.1 myisam_ftdump — Display Full-Text Index information
- 4.6.2 myisamchk — MyISAM Table-Maintenance Utility
- 4.6.3 myisamlog — Display MyISAM Log File Contents
- 4.6.4 myisampack — Generate Compressed, Read-Only MyISAM Tables
- 4.6.5 mysqlaccess — Client for Checking Access Privileges
- 4.6.6 mysqlbinlog — Utility for Processing Binary Log Files
- 4.6.7 mysqldumpslow — Summarize Slow Query Log Files
- 4.6.8 mysqlhotcopy — A Database Backup Program
- 4.6.9 mysqlmanagerc — Internal Test-Suite Program
- 4.6.10 mysqlmanager-pwgen — Internal Test-Suite Program
- 4.6.11 mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
- 4.6.12 mysql_explain_log — Use EXPLAIN on Statements in Query Log
- 4.6.13 mysql_find_rows — Extract SQL Statements from Files
- 4.6.14 mysql_fix_extensions — Normalize Table File Name Extensions
- 4.6.15 mysql_setpermission — Interactively Set Permissions in Grant Tables
- 4.6.16 mysql_tableinfo — Generate Database Metadata
- 4.6.17 mysql_waitpid — Kill Process and Wait for Its Termination
- 4.6.18 mysql_zap — Kill Processes That Match a Pattern
mysql_find_rows reads files containing SQL
statements and extracts statements that match a given regular
expression or that contain USE
or
db_nameSET
statements. The utility was written for use with update log
files and as such expects statements to be terminated with
semicolon (;) characters. It may be useful
with other files that contain SQL statements as long as
statements are terminated with semicolons.
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:
-
Display a help message and exit.
-
Display queries that match the pattern.
-
Quit after displaying
Nqueries. -
Do not include
USEstatements in the output.db_name -
Start output from this row.
User Comments
Add your own comment.