Skip to content
← Back to glossary

挿入Insert

Learn in the textbookBasics of Data Operations (Insert/Update and the Relational Operations for Retrieval)

DefinitionInsert (挿入) is the operation that writes a new row into a table.

ExplanationA table in a relational database is made of columns (fields), which represent attributes, and rows (records), each holding the data for one entry. In SQL, the INSERT statement adds a row by giving a value for each column. The primary key (主キー) column, which identifies a single row, must get a value that no other row already has.

AnalogyLike adding a line for a first-time customer to a shop's visitor list.

Memory hookThe kanji 挿 in 挿入 means to slip something in, which matches the picture of slipping a new row into a table.

Related past-exam questions(2 questions)