Drop files here

SQL upload ( 0 ) x -

Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Options
Restore default values
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:

world

City

Column Type Null Default Comments
ID (Primary) int(11) No
Name char(35) No
CountryCode char(3) No
District char(20) No
Population int(11) No 0

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No ID 4079 A No

Country

Column Type Null Default Comments
Code (Primary) char(3) No
Name char(52) No
Continent enum('Asia', 'Europe', 'North America', 'Africa', 'Oceania', 'Antarctica', 'South America') No Asia
Region char(26) No
SurfaceArea float(10,2) No 0.00
IndepYear smallint(6) Yes NULL
Population int(11) No 0
LifeExpectancy float(3,1) Yes NULL
GNP float(10,2) Yes NULL
GNPOld float(10,2) Yes NULL
LocalName char(45) No
GovernmentForm char(45) No
HeadOfState char(60) Yes NULL
Capital int(11) Yes NULL
Code2 char(2) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Code 239 A No

CountryLanguage

Column Type Null Default Comments
CountryCode (Primary) char(3) No
Language (Primary) char(30) No
IsOfficial enum('T', 'F') No F
Percentage float(4,1) No 0.0

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No CountryCode A No
Language 984 A No