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

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)

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  -