Proceedings of the 2018 3rd International Workshop on Materials Engineering and Computer Sciences (IWMECS 2018)

The Research and Implementation of Inserting Multi-row Records Based on Relational Database

Authors
Hongmei Luo
Corresponding Author
Hongmei Luo
Available Online April 2018.
DOI
10.2991/iwmecs-18.2018.59How to use a DOI?
Keywords
Relational Database; SQL Statement; INSERT; SELECT; UNION ALL
Abstract

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.

Copyright
© 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/).

Download article (PDF)

Volume Title
Proceedings of the 2018 3rd International Workshop on Materials Engineering and Computer Sciences (IWMECS 2018)
Series
Advances in Computer Science Research
Publication Date
April 2018
ISBN
10.2991/iwmecs-18.2018.59
ISSN
2352-538X
DOI
10.2991/iwmecs-18.2018.59How to use a DOI?
Copyright
© 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  -