Jump to content
Wikimedia Commons

File:SQL ANATOMY wiki.svg

From Wikimedia Commons, the free media repository
Original file (SVG file, nominally 831 ×ばつ 252 pixels, file size: 158 KB)

Captions

Captions

Add a one-line explanation of what this file represents
此圖表表示單個 SQL 中 SQL 語言的幾個組成元件
This SVG image was uploaded in a graphics format such as GIF, PNG, JPEG, or SVG. However, it consists purely or largely of information which is better suited to representation in wikitext (possibly using MediaWiki's special syntax for tables, math, or music). This will make the information easier to edit, as well as make it accessible to users of screen readers and text-based browsers.

If possible, please replace any inclusions of this image in articles (noted under the "File links" header) with properly formatted wikitext. After doing so, please consider nominating this image for deletion.

Deutsch ∙ English ∙ +/−

Summary

[edit ]
DescriptionSQL ANATOMY wiki.svg
English: This chart represents several constituent components of the SQL language in a single SQL Update (SQL) statement
Ελληνικά: Γλωσσικά στοιχεία σε ένα statement SQL
Date
Source Own work based on: Sql statement anatomy.png
Author :User:SqlPac, modified by Ferdna
Other versions

Sql statement anatomy.png (original)

 
This image shows some kind of formula that could be converted to TeX. Storing formulas as images makes it harder to change them. TeX also helps making sure that they all use the same font and size.
A replacement has been proposed. In your article, replace the image with this code.
U P D A T E   c l a u s e { U P D A T E   c o u n t r y S E T   c l a u s e { S E T   p o p u l a t i o n =   p o p u l a t i o n + 1 ⏞ e x p r e s s i o n W H E R E   c l a u s e { W H E R E   n a m e = ′ U S A ′ ⏟ e x p r e s s i o n ⏟ p r e d i c a t e ; } statement {\displaystyle \left.{\begin{array}{rl}\scriptstyle {\mathtt {UPDATE~clause}}&\{{\mathtt {UPDATE\ country}}\\\scriptstyle {\mathtt {SET~clause}}&\{{\mathtt {SET\ population=~}}\overbrace {\mathtt {population+1}} ^{\mathtt {expression}}\\\scriptstyle {\mathtt {WHERE~clause}}&\{{\mathtt {WHERE\ \underbrace {{name=}\underbrace {'USA'} _{expression}} _{predicate};}}\end{array}}\right\}\scriptstyle {\texttt {statement}}} {\displaystyle \left.{\begin{array}{rl}\scriptstyle {\mathtt {UPDATE~clause}}&\{{\mathtt {UPDATE\ country}}\\\scriptstyle {\mathtt {SET~clause}}&\{{\mathtt {SET\ population=~}}\overbrace {\mathtt {population+1}} ^{\mathtt {expression}}\\\scriptstyle {\mathtt {WHERE~clause}}&\{{\mathtt {WHERE\ \underbrace {{name=}\underbrace {'USA'} _{expression}} _{predicate};}}\end{array}}\right\}\scriptstyle {\texttt {statement}}}
<math>\left.

\begin{array}{rl} \scriptstyle\mathtt{UPDATE~clause} & \{ \mathtt{UPDATE\ country} \\ \scriptstyle\mathtt{SET~clause} & \{ \mathtt{SET\ population =~} \overbrace\mathtt{population + 1}^\mathtt{expression} \\ \scriptstyle\mathtt{WHERE~clause} & \{ \mathtt{WHERE\ \underbrace{{name =} \underbrace{'USA'}_{expression}}_{predicate};}

\end{array}\right\}\scriptstyle\texttt{statement}</math>
български ∙ Deutsch ∙ Ελληνικά ∙ English ∙ فارسی ∙ magyar ∙ italiano ∙ 日本語 ∙ македонски ∙ Nederlands ∙ polski ∙ русский ∙ sicilianu ∙ svenska ∙ +/−
TeX logo

Licensing

[edit ]
w:en:Creative Commons
attribution share alike This file is licensed under the Creative Commons Attribution-Share Alike 3.0 Unported 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.
This licensing tag was added to this file as part of the GFDL licensing update.http://creativecommons.org/licenses/by-sa/3.0/CC BY-SA 3.0Creative Commons Attribution-Share Alike 3.0truetrue

Original upload log

[edit ]

Transferred from en.wikipedia to Commons by MARKELLOS using CommonsHelper.

The original description page was here. All following user names refer to en.wikipedia.
  • 2008年01月21日 21:27 Ferdna ×ばつ (161860 bytes) use it as you like.
  • 2008年01月21日 19:11 Ferdna ×ばつ (14285 bytes) I made this file using the current(01/21/2008) .png image... you may use the file as you like. no restrictions at all. distribute freely.
  • 2008年01月21日 19:08 Ferdna ×ばつ (12429 bytes) I made this file using the current(01/21/2008) .png image... you may use the file as you like. no restrictions at all. distribute freely.

File history

Click on a date/time to view the file as it appeared at that time.

Date/TimeThumbnailDimensionsUserComment
current06:02, 14 August 2009 Thumbnail for version as of 06:02, 14 August 2009 831 ×ばつ 252 (158 KB)File Upload Bot (Magnus Manske) (talk | contribs) {{BotMoveToCommons|en.wikipedia|year={{subst:CURRENTYEAR}}|month={{subst:CURRENTMONTHNAME}}|day={{subst:CURRENTDAY}}}} {{Information |Description={{en|This chart represents several constituent components of the SQL language in a single SQL Update (SQL) s

You cannot overwrite this file.

The following 2 pages use this file:

File usage on other wikis

The following other wikis 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.

Width831
Height252

AltStyle によって変換されたページ (->オリジナル) /