By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,016 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

How do I automatically update column data from a .csv file uploaded every 2 hours.

P: 1
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...
May 30 '18 #1
Share this Question
Share on Google+
1 Reply


RedSon
Expert 5K+
P: 5,000
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
May 31 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.