Difference between revisions of "Scratch"

From WhyAskWhy.org Wiki
Jump to: navigation, search
m (test)
m (Testing new InterWiki prefixes.)
 
Line 1: Line 1:
<syntaxhighlight lang="mysql">
+
Example InterWiki prefixes:
# use the "my_database" database
 
USE my_database;
 
  
# show all "bath_towels" data
+
* [[amazon:0321544366|Amazon]]
SELECT * FROM bath_towels;
+
* [[informit:0321544366|InformIT]]
 
+
* [[oreilly:0636920023630|O'Reilly]]
# update specific fields in the "color" column
 
UPDATE bath_towels SET color = "Beige"
 
WHERE name = "Harvest";
 
 
 
UPDATE bath_towels SET color = "Blue"
 
WHERE name = "Dolphin";
 
 
 
UPDATE bath_towels SET color = "Lilac"
 
WHERE name = "Daisy";
 
 
 
UPDATE bath_towels SET name = "Tempest", color = "Maroon"
 
WHERE code = "821/9628";
 
 
 
# show all "bath_towels" data
 
SELECT * FROM bath_towels;
 
</syntaxhighlight>
 
 
 
 
 
Test text
 

Latest revision as of 08:29, 3 September 2012

Example InterWiki prefixes: