Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SQL
create table alumno(dni int primary key not null, nombre char(15), apellido char(15)) create table materias(cod_mat int primary key not null, nom_mat char(30), alu_dni int references alumno(dni)) create table comision(nom_com char(2) , alu_dni int references alumno(dni), mat_cod int references materias(cod_mat)) insert into alumno(dni,nombre,apellido) values(1,'Nico','J') insert into materias(cod_mat,nom_mat,alu_dni) values(1,'mate',1),(2,'lit.',1) insert into comision(nom_com,alu_dni,mat_cod) values(1,1,1),(1,1,2) select * from comision
run
|
edit
|
history
|
help
0
persons
Common Table Expression
Función Borrar carácter inicial repetido
new
TRAIN
q
Demo
Practice
viernes_ alumnos
Tarea1