How can I set a "download" button on the webpage for the data queried from the Mysql database and save it to the local computer in txt format?

After Real-time data is transmitted to the server, you can query the data for a certain period of time as needed, and then download the queried data to the specified location on the local computer.

After Real-time data is transmitted to the server, you can query the data for a certain period of time as needed, and then download the queried data to the specified location on the local computer.

Reply content:

After Real-time data is transmitted to the server, you can query the data for a certain period of time as needed, and then download the queried data to the specified location on the local computer.

It is easy to use Blob objects in js to construct data into a Bolb object and then generate a download link. But the browser must support html5.

Export and save the database program as txt to the server, and generate a download link. you can click to download

Use the SQL statement's INTO OUTFILE to export the query results INTO a txt file, and then return the file to the request.