Untitled query #16665

SQL

#What databases exist?
	#SHOW DATABASES;
#Select a database
USE simplewiki_p;
#Show all tables in the database
	#SHOW TABLES;
#Get info about a table
	#DESCRIBE page; 
#Select everything from a table (or some column), limit the number of entires like .head()
	#SELECT * FROM page LIMIT 10
#Order table
	#SELECT * FROM revision ORDER by rev_timestamp LIMIT 10
#Order table but descending
	#SELECT rev_page FROM revision ORDER by rev_timestamp DESC limit 10
SELECT rev_page, page_title, rev_timestamp FROM revision JOIN page ON rev_page = page_id ORDER by rev_timestamp ASC limit 10;
SQL

Checking query status...
