The Research and Implementation of Inserting Multi-row Records Based on Relational Database
- 10.2991/iwmecs-18.2018.59How to use a DOI?
- Relational Database; SQL Statement; INSERT; SELECT; UNION ALL
In the process of program development, it is often necessary to insert multi rows of explicitly specified values into one table of relational database at a time, and we hope to achieve this insertion by only one statement.But in the standard SQL statement, there is no such a SQL syntax. In this paper, through the study of 'INSERT ', 'SELECT' and 'UNION ALL' statements, a simple and effective implementation method is given.
- © 2018, the Authors. Published by Atlantis Press.
- Open Access
- This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).
Cite this article
TY - CONF AU - Hongmei Luo PY - 2018/04 DA - 2018/04 TI - The Research and Implementation of Inserting Multi-row Records Based on Relational Database BT - Proceedings of the 2018 3rd International Workshop on Materials Engineering and Computer Sciences (IWMECS 2018) PB - Atlantis Press SP - 273 EP - 277 SN - 2352-538X UR - https://doi.org/10.2991/iwmecs-18.2018.59 DO - 10.2991/iwmecs-18.2018.59 ID - Luo2018/04 ER -