fork download
  1. -- your code goes here
  2.  
  3. insert into Etudiant ( nom , prenom , age ) VALUES
  4. ('agrari', 'Omar',20),('amine', 'houssam eddine',20);
  5. insert into matiere (nom, coefficient) values ('math', 8),
  6. ('info', 1);
  7. insert into classe (nom) values('G5');
  8. insert into classe (nom) values('G1');
  9. insert into classe (nom) values('G2');
  10. insert into classe (nom) values('G3');
  11. insert into classe (nom) values('G4');
  12. select * from Etudiant;
  13.  
  14. insert into inscription(id_etudiant, id_classe) values(2,1);
  15.  
  16. desc note;
  17. alter table note add column note float;
  18. insert into note (id_etudiant,id_matiere, note) values (1,1,1);
  19.  
  20. select * from etudiant;
  21.  
  22. update etudiant set age=21 where id=1;
  23.  
  24. insert into enseignant (nom, specialite) values('tahar', 'dataStructures');
  25.  
  26. update enseignant set nom='allal' where id=1;
  27. select * from enseignant;
  28.  
  29. update note set note=note+1;
  30.  
  31. update Matiere set coefficient =5 where id=1;
  32.  
  33. select * from matiere;
  34.  
  35. update Inscription
  36. set id_classe=1
  37. where id_etudiant=1;
  38.  
  39. alter table note drop constraint note_ibfk_2;
  40. delete from Etudiant
  41. where id =1;
  42.  
  43. alter table inscription add constraint fk_note_etu
  44. foreign key (id_etudiant) references etudiant(id)
  45. on delete set null;
  46.  
  47. alter table note add constraint fk_insc_etu
  48. foreign key (id_etudiant) references etudiant(id)
  49. on delete set null;
  50.  
  51. delete from matiere where id=2;
  52.  
  53. create table abscences(
  54. id int auto_increment primary key,
  55. id_etudiant int,
  56. date_absence date,
  57. seance_absence int);
  58.  
  59. insert into abscences(id_etudiant, date_absence, seance_absence) values (2,'2025-1-1', 1);
  60.  
  61.  
  62. select * from abscences;
  63.  
  64. delete from note where note<10;
  65.  
  66. delete from abscences where id=1;
  67.  
  68. select * from etudiant where age>20;
  69.  
  70. select * from note where note>12;
  71.  
  72. select * from matiere where coefficient >3;
  73.  
  74. select * from enseignant where specialite='datastructures';
  75.  
  76. select * from abscences where id_etudiant=2;
  77.  
  78. select * from inscription where id_classe=1;
  79.  
  80. select * from note where id_etudiant=1;
  81.  
  82. select * from etudiant;
  83. select * from etudiant where nom like '_g%';
  84.  
  85.  
Success #stdin #stdout #stderr 0.01s 5288KB
stdin
Standard input is empty
stdout
|2|2025-1-1|1
|2|2025-1-1|1
stderr
Error: near line 3: no such table: Etudiant
Error: near line 5: no such table: matiere
Error: near line 7: no such table: classe
Error: near line 8: no such table: classe
Error: near line 9: no such table: classe
Error: near line 10: no such table: classe
Error: near line 11: no such table: classe
Error: near line 12: no such table: Etudiant
Error: near line 14: no such table: inscription
Error: near line 16: near "desc": syntax error
Error: near line 17: no such table: note
Error: near line 18: no such table: note
Error: near line 20: no such table: etudiant
Error: near line 22: no such table: etudiant
Error: near line 24: no such table: enseignant
Error: near line 26: no such table: enseignant
Error: near line 27: no such table: enseignant
Error: near line 29: no such table: note
Error: near line 31: no such table: Matiere
Error: near line 33: no such table: matiere
Error: near line 35: no such table: Inscription
Error: near line 39: near "drop": syntax error
Error: near line 40: no such table: Etudiant
Error: near line 43: no such table: inscription
Error: near line 47: no such table: note
Error: near line 51: no such table: matiere
Error: near line 64: no such table: note
Error: near line 68: no such table: etudiant
Error: near line 70: no such table: note
Error: near line 72: no such table: matiere
Error: near line 74: no such table: enseignant
Error: near line 78: no such table: inscription
Error: near line 80: no such table: note
Error: near line 82: no such table: etudiant
Error: near line 83: no such table: etudiant