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)
Captions
Captions
Anatomy of a SQL update query
Summary edit
This vector image was created with LaTeX.
| Description |
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 | 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:
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 | | 942 × 358 (69 KB) | Psiĥedelisto (talk | contribs) | fix column label |
| 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.
