469,590 Members | 2,464 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,590 developers. It's quick & easy.

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

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
1 1763
RedSon
5,000 Expert 4TB
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.

Similar topics

2 posts views Thread by oscar78 | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.