Talk:SQL syntax
Add topicLatest comment: 1 year ago by Jpgrassi in topic Broken links after deletion of Where page
| This is the talk page for discussing improvements to the SQL syntax article. This is not a forum for general discussion of the subject of the article. |
Article policies
|
| Find sources: Google (books · news · scholar · free images · WP refs) · FENS · JSTOR · TWL |
 | This article is rated C-class on Wikipedia's content assessment scale. It is of interest to the following WikiProjects: | ||||||||||||||||||||
| |||||||||||||||||||||
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)
- 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)
Broken links after deletion of Where page
[edit]The "Where" page got deleted in Wikipedia:Articles for deletion/Where (SQL) but the SQL Syntax page still links to it inside the "Operators" table, for example in the "IN" example. Jpgrassi (talk) 09:59, 27 January 2025 (UTC)