MySQL Query Tester
Username:
MySQL password:
SQL query:
Database:
world
simpsons
imdb_small
imdb
(please test on imdb_small first!)
world:
countries
Other columns:
region
,
surface_area
,
life_expectancy
,
gnp_old
,
local_name
,
government_form
,
capital
,
code2
code
name
continent
independence_year
population
gnp
head_of_state
...
AFG
Afghanistan
Asia
1919
22720000
5976.0
Mohammad Omar
...
NLD
Netherlands
Europe
1581
15864000
371362.0
Beatrix
...
...
...
...
...
...
...
...
...
cities
id
name
country_code
district
population
3793
New York
USA
New York
8008278
1
Los Angeles
USA
California
3694820
...
...
...
...
...
languages
country_code
language
official
percentage
AFG
Pashto
T
52.4
NLD
Dutch
T
95.6
...
...
...
...
simpsons:
students
id
name
email
password
123
Bart
bart@fox.com
bartman
456
Milhouse
milhouse@fox.com
fallout
888
Lisa
lisa@fox.com
vegan
404
Ralph
ralph@fox.com
catfood
teachers
id
name
1234
Krabappel
5678
Hoover
9012
Stepp
courses
id
name
teacher_id
10001
Computer Science 142
1234
10002
Computer Science 143
5678
10003
Computer Science 154
9012
10004
Informatics 100
1234
grades
student_id
course_id
grade
123
10001
B-
123
10002
C
404
10002
B
404
10004
D+
456
10001
B+
456
10002
D-
888
10002
A+
888
10003
A+
imdb and imdb_small:
actors
id
first_name
last_name
gender
film_count
433259
William
Shatner
M
162
797926
Britney
Spears
F
65
831289
Sigourney
Weaver
F
72
...
movies
id
name
year
rank
112290
Fight Club
1999
8.5
209658
Meet the Parents
2000
7
210511
Memento
2000
8.7
...
roles
actor_id
movie_id
role
433259
313398
Capt. James T. Kirk
433259
407323
Sgt. T.J. Hooker
797926
342189
Herself
...
movies_genres
movie_id
genre
209658
Comedy
313398
Action
313398
Sci-Fi
...
directors
id
first_name
last_name
24758
David
Fincher
66965
Jay
Roach
72723
William
Shatner
...
movies_directors
director_id
movie_id
24758
112290
66965
209658
72723
313398
...