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:

StdMdDB

course

Column Type Null Default Comments
id (Primary) int(11) No
label varchar(50) No
hours_number int(11) No

Indexes

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

score

Column Type Null Default Comments
student_id int(11) No
course_id int(11) No
student_score float No
description varchar(150) No

No index defined!

student

Column Type Null Default Comments
id (Primary) int(11) No
first_name varchar(50) No
last_name varchar(50) No
gender char(1) No
birthdate date No
phone varchar(50) No
address text No

Indexes

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

user

Column Type Null Default Comments
id (Primary) int(11) No
username varchar(50) No
password varchar(50) No
date created date No

Indexes

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