Webmaster Forum

Go Back   Webmaster Forum > Web Development > Coding Forum

Coding Forum Problems with your code? Discuss coding issues, including JavaScript, PHP & MySQL, HTML & CSS, Flash & ActionScript, and more.


 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Share |
  #1  
Old 01-20-2018, 11:58 AM
poster poster is offline
Contributing Member
 
Join Date: 05-01-06
Location: San Francisco, CA
Posts: 126
iTrader: 0 / 0%
MySQL Questions

I have a MySQL question.

I am calling a JSON API, which I can covert into 1,000 rows of data, e.g.

Let's say I have these columns: id, ticker, title, description, price, info, date.

I need to update "price", "info", and "date" every 5 minutes from the API and if there are new rows I need to insert them into MySQL.

JSON data does not have the "id" in it, I am going to create it in MySQL. The only unique column in the JSON data is the "ticker". I need to have the id stay constant for each ticker as this data is being used in other places, so
I need to match up the "ticker" in the JSON file with the "ticker" column in MySQL.

I can call a PHP script every 5 minutes, so it's not an issue but what about the rest? Do I do 1,000 updates and then INSERT IGNORE?
 

Advertisement

Advertisement

Go Back   Webmaster Forum > Web Development > Coding Forum

 


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching for PHP + MySql script Haki123 Coding Forum 0 09-17-2017 08:46 AM
Where Can I Post My Questions? Hamda shah V7N Forum Support 1 06-11-2017 06:47 AM
9 Tips for Fielding Customer Questions on Social Media snakeair Online Business Forum 0 05-18-2017 07:40 AM


V7N Network
Get exposure! V7N I Love Photography V7N SEO Blog V7N Directory


All times are GMT -7. The time now is 04:29 AM.
Powered by vBulletin
Copyright 2000-2014 Jelsoft Enterprises Limited.
Copyright © 2003 - 2018 VIX-WomensForum LLC