This article is within the scope of WikiProject Databases, a project which is currently considered to be inactive.DatabasesWikipedia:WikiProject DatabasesTemplate:WikiProject DatabasesDatabases articles
This article has not yet received a rating on Wikipedia's content assessment scale.
Do DELETE, INSERT and UPDATE count as queries?[edit]
The DELETE, INSERT and UPDATE statements are covered under the "Queries" section, but the SELECT statement is referred to as "the query". Do DELETE, INSERT and UPDATE count as queries? (If not, maybe they should be moved out of the section named "Queries".) makeswell (talk) 18:43, 24 March 2023 (UTC)[reply]
No, DELETE, INSERT and UPDATE are statements, not queries.
ISO/IEC 9075-2:2016(E)
14.8 <delete statement: positioned>
14.9 <delete statement: searched>
14.11 <insert statement>
14.13 <update statement: positioned>
14.14 <update statement: searched>
Positioned means using a cursor, WHERE CURRENT OF cursorname
Searched means using a WHERE clause. (Or without a WHERE, but no cursor involved.) Fjerdingen (talk) 18:55, 24 March 2023 (UTC)[reply]
