Live briefing
Everything about Prepared statement
Database feature
In database management systems (DBMS), a prepared statement, parameterized statement, is a feature where the database pre-compiles SQL code and stores the results, separating it from data. Benefits of prepared statements are:efficiency, because they can be used repeatedly without re-compiling security, by reducing or eliminating SQL injection attacks Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Prepared statementA 5-minute orientation
- Skim a recent paper: Retraction statement: Hyaluronic acid‐rich burger separator edible disc prepared from slaughterhouse wasteInfluential work since 2022
- Pick up a classic book: Graduate SchoolThe most-reprinted book on the subject
- Read the landmark paper: On automated prepared statement generation to remove SQL injection vulnerabilitiesCited 48 times
- Go sideways: Active record patternA closely related topic
- Go sideways: Java Database ConnectivityA closely related topic
📖 Definitions
Noun Used other than figuratively or idiomatically: see prepared, statement.
Noun A database query that has parameters which are replaced by values when it is executed, instead of the values being part of the statement itself.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
On automated prepared statement generation to remove SQL injection vulnerabilities
Pontifical Academy for Life Statement: Moral Reflections on Vaccines Prepared from Cells Derived from Aborted Human Foetuses
Priorities in medicine. Statement prepared by the B.M.A. Planning Unit.
Prepared Statement on the Space Program
EPSC: Testing Database Management Systems via Equivalent Prepared Statement Construction
STATEMENT PREPARED BY THE NATIONAL HEALTH COMMISSIONERS
STATEMENT PREPARED BY THE NATIONAL HEALTH COMMISSIONERS
STATEMENT PREPARED BY THE NATIONAL HEALTH COMMISSIONERS
🆕 Influential since 2022
📚 Books worth reading
Graduate SchoolDave G. Mumby, Ph.D. · 2011
Guides to environmental planning, assessments and impact statements for water quality management plans and municipal wastewater treatment projectsUS Environmental Protection Agency. Region I. · 1975
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Active record pattern In software engineering, the active record pattern is an architectural pattern. It is found in software that stores in-memory object data in relational…
- Java Database Connectivity Java Database Connectivity (JDBC) is an application programming interface (API) for the Java programming language which defines how a client may access…
- MySQLi The MySQLi Extension (MySQL Improved) is a relational database driver used in the PHP scripting language to provide an interface with MySQL protocol compatible…
- Comparison of relational database management systems The following tables compare general and technical information for a number of relational database management systems. Please see the individual products'…
- 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…
- Data source name In computing, a data source name (DSN, sometimes known as a database source name, though "data sources" can comprise other repositories apart from databases)…
- Stored procedure A stored procedure (also termed prc, proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access…