Digital Marketing

Sample shell script to import files into MySQL database

After importing files, you can create an event in MySQL to continue to process those imported data. Creating an event is a better way because if you execute those SQL queries from shell, it may encounter connection timed out etc if it takes long time to process those data.
CREATE EVENT process_data_after_import_event ON SCHEDULE 
AT CURRENT_TIMESTAMP + INTERVAL 3 SECOND
DO CALL process_data_after_import();

Comments

Popular posts from this blog

How to fix Google Apps Script: Script function not found: doGet

Selenium supports Java

Creating sort index in MySQL