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)) go create table materias(cod_mat int primary key not null,nom_mat char(30),alu_dni int references alumno(dni)) go create table comision(nom_com char(2) ,alu_dni int references alumno(dni),mat_cod int references materias(cod_mat)) go insert into alumno(dni,nombre,apellido) values(1,'Nico','J') go insert into materias(cod_mat,nom_mat,alu_dni) values(1,'mate',1),(2,'lit.',1) go insert into comision(nom_com,alu_dni,mat_cod) values(1,1,1),(1,1,2) go select * from comision go
run
|
edit
|
history
|
help
0
Chris
Create Date list (variable dates) - SQL Server
text
bdLojaRoupas
Display Multiple Rows as a single Line
Find users who have been watching kid's programmes for 13 weeks
ASSESSMENT2
Delete cascade
Insert index into Temporary Table
Items