How to run a MySQL query on every service start?

Question

I need to run a query to populate a memory table on every MySQL start.

Is there any way to do this?

Answer 1

MySQL is able to read statements from init_file on startup.

You'd have to place the following in my.ini or my.cnf (depending on the OS) file

[mysqld] 
init-file="/path/to/your/query/populate_memory_table.sql"