How to find a new row in a MySQL table and output it to a text file using Bash?

Question

MySQL

There is a security alarm panel where all alarm events appear as new rows in a table in the MySQL database. How to organize the search for this new line and output it to a text file? Well, there, by means of telegram, on duty on mobile phones through crowns, it’s understandable :).

Answer 1

Well, this command will output the line with the maximum ID to the file:

mysql -u username -p 'password' -e 'SELECT * FROM table ORDER BY id DESC LIMIT 1' > output.txt

Answer 2

diff (event select) (old select)
or vice versa.
(grep and awk to taste)

Answer 3

mysql dbname -e "SELECT col1, col2,... FROM tbname WHERE......;" >> query.txt

It's like outputting the result to a text file.
The query itself depends on how your database is set up.