Method, device and equipment for batch generation of sql format data and storage medium
The invention relates to the technical field of database data processing, in particular to a method and device for generating sql format data in batches, equipment and a storage medium. Comprising the steps of obtaining target data in a target excel table; performing data splicing by using the targe...
Saved in:
| Main Author | |
|---|---|
| Format | Patent |
| Language | Chinese English |
| Published |
29.08.2023
|
| Subjects | |
| Online Access | Get full text |
Cover
Loading…
| Summary: | The invention relates to the technical field of database data processing, in particular to a method and device for generating sql format data in batches, equipment and a storage medium. Comprising the steps of obtaining target data in a target excel table; performing data splicing by using the target data in the excel table; the data splicing result is uploaded to a target server through a JSch method by using the data splicing result; and executing a related execution command by utilizing the result uploaded to the target server, and importing or updating the data splicing result into a target database in batches. The target data in the excel table is utilized for data splicing, and the problems that when the excel table data is imported into or updated to a related database in a batch mode, existing software is used, batch importing or updating of the data is not supported, and the requirement for the format of the data needing to be imported is high are solved.
本申请涉及数据库数据处理技术领域，尤其涉及批量生成sql格式数据的方法、装置、设备及存储介 |
|---|---|
| Bibliography: | Application Number: CN202310411374 |