File:SQL UPDATE query.svg
From Wikimedia Commons, the free media repository
File:SQL UPDATE query.svg
Size of this PNG preview of this SVG file: 800 ×ばつ 304 pixels. Other resolutions: 320 ×ばつ 122 pixels | 640 ×ばつ 243 pixels | 1,024 ×ばつ 389 pixels | 1,280 ×ばつ 486 pixels | 2,560 ×ばつ 973 pixels | 942 ×ばつ 358 pixels.
Original file (SVG file, nominally 942 ×ばつ 358 pixels, file size: 69 KB)
File information
Structured data
Captions
Captions
Anatomy of a SQL update query
Summary
[edit ]
DescriptionSQL UPDATE query.svg
English: Anatomy of a SQL update query, based loosely on File:Sql statement anatomy.png by User:SqlPac.
Date
Source
Own work
Author
Psiĥedelisto
Source code
InfoField
LaTeX code
\documentclass[class=extarticle,margin=1cm,20pt]{standalone} \begin{document} \fontfamily\ttdefault\selectfont $\underbrace{\left. \begin{array}{rl} \textstyle$\itshape\ttfamily{UPDATE~clause\upshape{:}} $ & \{\mathtt{UPDATE\\overbrace{\mathtt{countries}}^\mathtt{table}} \}\\ \textstyle$\itshape\ttfamily{SET~clause\upshape{:}} $ & \{ {\mathtt{SET\\overbrace{\mathtt{population}}^\mathtt{column} =~} \overbrace{\mathtt{{population} +\underbrace{\mathtt{1}}_\mathtt{literal}}}^\mathtt{expression}} \}\\ \textstyle$\itshape\ttfamily{WHERE~clause\upshape{:}} $ & \{ {\mathtt{WHERE\\underbrace{\overbrace{\mathtt{name}}^\mathtt{column} \mathtt{=} \overbrace{{\overbrace{\mathtt{'USA'}}^\mathtt{literal}}}^\mathtt{expression}}_\mathtt{predicate}}\}{\texttt{;}}} \end{array} \right\}{\textstyle\texttt{statement}}}_{\textstyle\texttt{SQL query}}$ \end{document}
Licensing
[edit ]I, the copyright holder of this work, hereby publish it under the following license:
w:en:Creative Commons
attribution share alike
attribution share alike
This file is licensed under the Creative Commons Attribution-Share Alike 4.0 International license.
- You are free:
- to share – to copy, distribute and transmit the work
- to remix – to adapt the work
- Under the following conditions:
- attribution – You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
- share alike – If you remix, transform, or build upon the material, you must distribute your contributions under the same or compatible license as the original.
File history
Click on a date/time to view the file as it appeared at that time.
| Date/Time | Thumbnail | Dimensions | User | Comment | |
|---|---|---|---|---|---|
| current | 07:26, 22 September 2022 | Thumbnail for version as of 07:26, 22 September 2022 | 942 ×ばつ 358 (69 KB) | Psiĥedelisto (talk | contribs) | fix column label |
| 07:17, 22 September 2022 | Thumbnail for version as of 07:17, 22 September 2022 | 512 ×ばつ 236 (72 KB) | Psiĥedelisto (talk | contribs) | Uploaded own work with UploadWizard |
You cannot overwrite this file.
File usage on Commons
There are no pages that use this file.
Metadata
This file contains additional information such as Exif metadata which may have been added by the digital camera, scanner, or software program used to create or digitize it. If the file has been modified from its original state, some details such as the timestamp may not fully reflect those of the original file. The timestamp is only as accurate as the clock in the camera, and it may be completely wrong.
| Width | 753.37pt |
|---|---|
| Height | 286.61pt |
