How to realize that a large amount of data is sent by api, and then the returned fields are written to the local database?

Local plans to write a large amount of data to another database. A tag field is returned for each piece of data written successfully. This field needs to be updated to the local corresponding data, using whether php, can use php script to run

.
May.10,2021

Why not use tools to import directly?

  • if it is a formatted text data file, you can import it directly using the database tool.
  • if it is database-to-database, there is a special backup and recovery tool for the corresponding database, which is faster and better than api .

it depends on exactly what you are going to do and what is the relevance of your business. It is not clear enough

  • Sku similar to Taobao

    first of all, I found a lot of database design on Baidu, it can be said that there are different opinions! I see an intermediate table is designed like this, commodity ID sku attributes, unit price inventory, see that the intermediate attributes store js...

  • What is the maximum size of a table in mysql?

    I am a rookie. I set up a website because I had to record a table of mysql caused by each visit of user agent,. 100000 rows of data were recorded in a year, which became the size of 50Mb. However, from a sensory point of view, it does not seem to affect...

    Apr.03,2021
  • How to express the success of the query?

    Please see here expression of successful query if ($conn->query($sql) === TRUE) { echo ""; } else { echo "Error: " . $sql . "<br>" . $conn->error; } Please see my code: <form action=""...

    Apr.09,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1eb3805-48236.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1eb3805-48236.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?