Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
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
Set default
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:

test19

cours

Column Type Null Default Comments
Id_voiture (Primary) int(11) No
Id_saison (Primary) int(11) No
Id_rallye (Primary) int(11) No
Id_pilote (Primary) int(11) No
Nbr_point int(11) Yes NULL

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Id_saison 0 A No
Id_voiture 0 A No
Id_rallye 0 A No
Id_pilote 0 A No

ecurie

Column Type Null Default Comments
Id_ecurie (Primary) int(11) No
Nom_ecurie varchar(30) No
Nb_titre int(11) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Id_ecurie 4 A No

pilote

Column Type Null Default Comments
Id_pilote (Primary) int(11) No
Nom_pilote varchar(30) No
Prenom_pilote varchar(30) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Id_pilote 30 A No

rallye

Column Type Null Default Comments
Id_rallye (Primary) int(11) No
Nom_rallye varchar(30) No
Lieu_rallye varchar(30) No
Type_piste varchar(30) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Id_rallye 0 A No

RK

Column Type Null Default Comments
Id_speciale (Primary) int(11) No
Id_saison (Primary) int(11) No
Id_pilote (Primary) int(11) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Id_speciale 0 A No
Id_saison 0 A No
Id_pilote 0 A No

speciale

Column Type Null Default Comments
Id_speciale (Primary) int(11) No
Date_speciale date No
Heure_debut time No
Heure_fin time No
Lieu_speciale varchar(30) No
distance_speciale int(11) Yes NULL
Id_rallye int(11) Yes NULL

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Id_speciale 0 A No
Id_rallye BTREE No No Id_rallye 0 A Yes

voiture

Column Type Null Default Comments
Id_voiture (Primary) int(11) No
Modele_voiture varchar(30) No
Id_ecurie int(11) Yes NULL

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Id_voiture 0 A No
Id_ecurie BTREE No No Id_ecurie 0 A Yes