File:SQLクエリ.svg
Summary
| Description |
English: Anatomy of a SQL update query, based loosely on File:Sql statement anatomy.png by User:SqlPac. (Japanese version) |
| Date | |
| Source | Own work |
| Author | Psiĥedelisto |
| Source code | LaTeX code\documentclass[class=ltjarticle,margin=1cm]{standalone}
\usepackage{relsize}
\usepackage{luatexja-fontspec}
\setsansjfont{Rounded Mplus 1c}
\setmainjfont{Rounded Mplus 1c}
\begin{document}
\fontfamily\ttdefault\selectfont
\relscale{3}
$\underbrace{\left. \begin{array}{rl} \mathtt{UPDATE句{\textstyle\texttt{:}}} & {\textstyle\texttt{\{}} \mathtt{UPDATE\ \overbrace{\mathsf{世界各国}}^\mathsf{テーブル名}} {\textstyle\texttt{\}}} \\
\\
\mathtt{SET句{\textstyle\texttt{:}}} & {\textstyle\texttt{\{}} {\mathtt{SET\ \overbrace{\mathsf{人口}}^\mathsf{カラム名} =~} \overbrace{{\underbrace{\mathsf{人口}}_\mathsf{カラム名}~\mathtt{+}~\underbrace{\mathtt{1}}_\mathsf{直値}}}^\mathsf{式}} {\textstyle\texttt{\}}} \\
\\
\mathtt{WHERE句{\textstyle\texttt{:}}} & {\textstyle\texttt{\{}} {\mathtt{WHERE\ \overbrace{\overbrace{\mathsf{国名}}^\mathsf{カラム名}~\mathtt{=}~\overbrace{{\underbrace{\mathtt{'}\mathsf{日本}\mathtt{'}}_\mathsf{直値}}}^\mathsf{式}}^\mathsf{条件式}}{\textstyle\texttt{\}}}{\underbrace{\texttt{;}}_\mathsf{終了記号}}}
\end{array}
\right \}{\mathsf{(更新) \atop 文}}}_{\mathtt{SQLクエリ}}$
\end{document}
|
Licensing
This file is licensed under the Creative Commons Attribution-Share Alike 4.0 International license.
Attribution:
Fredrick R. Brennan (フレッド・ブレンナン) (User:Psiĥedelisto)
- 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.
