File:SQL UPDATE query.svg
Summary
| 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
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.
