Wikimore

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 ∙ +/−

Category:Convert to TXT#SQL%20ANATOMY%20wiki.svg

Summary

Description

English: This chart represents several constituent components of the SQL language in a single SQL Update (SQL) statement

Ελληνικά: Γλωσσικά στοιχεία σε ένα statement SQL

Date

21 January 2008

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:

\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}}

In your article, replace the image with:

<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 ∙ italiano ∙ magyar ∙ Nederlands ∙ polski ∙ sicilianu ∙ svenska ∙ Ελληνικά ∙ български ∙ македонски ∙ русский ∙ 日本語 ∙ فارسی ∙ +/−

Category:Images with a TeX equivalent

Licensing

	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.CC BY-SA 3.0truetrue

Category:CC-BY-SA-3.0-migrated#SQL%20ANATOMY%20wiki.svg Category:License migration completed#SQL%20ANATOMY%20wiki.svg

Original upload log

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 831×252× (161860 bytes) use it as you like.
2008-01-21 19:11 Ferdna 831×252× (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 831×252× (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.

Category:Data management Category:Structured Query Language Category:Syntax

Wikimore

File:SQL ANATOMY wiki.svg

Summary

Licensing

Original upload log