Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Caronas
CREATE TABLE MOTORISTAS( id CHAR(8) NOT NULL, nome VARCHAR(60) NOT NULL, num_registro CHAR(12) NOT NULL, med_aval FLOAT NOT NULL, PRIMARY KEY(id)); CREATE TABLE PASSAGEIROS( id CHAR(8) NOT NULL, nome VARCHAR(60) NOT NULL, PRIMARY KEY(id)); CREATE TABLE VIAGENS( motorista_id CHAR(8) NOT NULL, passageiro_id CHAR(8) NOT NULL, data_inicio TIMESTAMP NOT NULL, km_rodados INT, FOREIGN KEY (motorista_id) REFERENCES MOTORISTAS, FOREIGN KEY (passageiro_id) REFERENCES PASSAGEIROS);
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
correlated subquery & top & view & derived table & group by
Arun
database size
Max from multiple columns
TUAN 7_QLDT
stackoverflow_mysql_demo_data
Factorial
How to find 2nd highest salary
persons
Fff
Please log in to post a comment.