Noob alert. I have an inventory table with the last column being 'Quanity'. I need to make it so that my client can upload a .csv via FTP containing current Quantity data every two hours and the table will refresh using the latest column data automatically. Thank you in advance. Please use laymen's terms, very new to this stuff...
-
-
Thats a pretty sophisticated requirement for a "noob", however one way to solve this would be to create a cron job which run every two hours. I suspect you're a bit farther along than "noob" but neverthelesss.. . try running a command like mysqlimport to load the data in each time. https://dev.mysql.com/doc/refman/8.0...sqlimport.html
Cron: https://linux.die.net/man/5/crontab
Comment