mysql - 用于 INSERT INTO 的 awk General-query.log

Question

我有一个很大的 mysql 常规查询日志，如下所示:

110301  2:19:29  268341 Query       SELECT option_value FROM wp_options WHERE option_name = 'sidebars_widgets' LIMIT 1
             268341 Query       SELECT autoload FROM wp_options WHERE option_name = 'rewrite_rules'
             268341 Query       DELETE FROM wp_options WHERE option_name = 'rewrite_rules'
             268341 Query       SELECT option_value FROM wp_options WHERE option_name = 'rewrite_rules' LIMIT 1
             268341 Query       SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category')  ORDER BY t.name ASC
             268341 Query       SELECT ID, post_name, post_parent FROM wp_posts WHERE post_type = 'page'
             268341 Query       SELECT * FROM wp_posts WHERE ID = 9191 LIMIT 1
             268341 Query       SELECT ID, post_name, post_parent FROM wp_posts WHERE post_type = 'attachment' AND post_parent = 9191
             268341 Query       SELECT * FROM wp_posts WHERE ID = 8805 LIMIT 1

我想使用 AWK 查找所有 INSERT INTO 语句吗？

Answer 1

gawk "/INSERT INTO/" query.log

我认为您将进行额外的处理，否则如前所述，您实际上并不需要 awk。