Live briefing
Everything about Insert (SQL)
SQL statement
An SQL INSERT statement adds one or more records to any single table in a relational database. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Insert (SQL)A 5-minute orientation
- Pick up a classic book: Database system conceptsThe most-reprinted book on the subject
- Read the landmark paper: An Extension of RETRO Framework: Translating SQL Insert, Update and Delete Queries to SPARQL UPDATECited 0 times
- Go sideways: Database triggerA closely related topic
- Go sideways: Merge (SQL)A closely related topic
📖 Definitions
No dictionary entry for this exact phrase.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
📚 Books worth reading
Database system conceptsAbraham Silberschatz · 1997
Access database design & programmingSteven Roman · 1997
PHP for the World Wide WebLarry Ullman · 2001
Sams teach yourself SQL in 10 minutesBen Forta · 1999
Introduction to Computing Using PythonLjubomir Perkovic · 2011
Dreamweaver MXRay West, Thomas Muck · 2002
Data science from scratchJoel Grus · 2015
Head First C♯Andrew Stellman · 2007
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Database trigger A database trigger is procedural code that is automatically executed in response to specific events on a table or view in a database. Triggers are commonly…
- Merge (SQL) A relational database management system uses SQL MERGE (also called upsert) statements to INSERT new records or UPDATE or DELETE existing records depending…
- Select (SQL) The SQL SELECT statement returns a result set of rows, from one or more tables. A SELECT statement retrieves zero or more rows from one or more database…
- PL/SQL PL/SQL (Procedural Language for SQL) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle…
- Comparison of programming languages (associative array) This comparison of programming languages (associative arrays) compares the features of associative array data structures or array-lookup processing for…
- Virtual column In relational databases a virtual column is a table column whose value(s) is automatically computed using other columns values, or another deterministic…
- SQL syntax The syntax of the SQL programming language is defined and maintained by ISO/IEC SC 32 as part of ISO/IEC 9075. This standard is not freely available. Despite…
- Prepared statement In database management systems (DBMS), a prepared statement, parameterized statement, (not to be confused with parameterized query) is a feature where…