W3cubDocs

/MariaDB

mysql_find_rows

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 was written for use with update log files (as used prior to MySQL 5.0) 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.

From MariaDB 10.4.6, mariadb-find-rows is a symlink to mysql_find_rows.

Usage

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.

Options

mysql_find_rows supports the following options:

Option Description
--help, --Information Display help and exit.
--regexp=pattern Display queries that match the pattern.
--rows=N Quit after displaying N queries.
--skip-use-db Do not include USE db_name statements in the output.
--start_row=N Start output from this row (first row is 1).

Examples

mysql_find_rows --regexp=problem_table --rows=20 < update.log
mysql_find_rows --regexp=problem_table  update-log.1 update-log.2
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/mysql_find_rows/