What is "insert"

Insertion refers to the act of storing data in a computerised system in a logical and structured or semi-structured way, by means of a specific command or operator. Usually applies to a relational, through the operator insert, but can also be used in non-relational databases ("Nosql") or other structured data repositories.

In a system that supports 4 basic operations CRUD (or VEIN: View, Delete, Insert, Change), the act of Insert consists of popular this system with data that (in addition to maintained through changes and removals) can later be consulted through parameters and/or filters that act in its structured part. This operation must be an explicit and well-defined functionality in such a system. For the purpose of this tag, the insertion operation must also accept parameters in order to establish a certain logical - albeit partial - structure that allows the entered data to be searched individually or aggregated according to that structure (i.e. an operation that simply accumulates data that can only be recovered as a whole - for example adding content to a file that can only be read integer - does not consist of an insertion by that definition).

Summary: use this tag when

  • Your program/application/script interacts with a data storage system...
  • by means of an interface external... (i.e. which does not simply assign values to the programme’s own data structures)
  • through an explicit operation of store data in the same...
  • so structured or semi-structured.
  • And your question relates to the correct use of/troubleshooting with this operation.