fork download
  1. CREATE TABLE S1(
  2. SID INT,
  3. SNAME VARCHAR(16),
  4. RATING INT,
  5. AGE INT,
  6. PRIMARY KEY(SID)
  7. );
  8.  
  9. CREATE TABLE S2(
  10. SID INT,
  11. SNAME VARCHAR(16),
  12. RATING INT,
  13. AGE INT,
  14. PRIMARY KEY(SID)
  15. );
  16.  
  17. CREATE TABLE R1(
  18. SID INT,
  19. BID INT,
  20. DAY VARCHAR(20),
  21. );
  22.  
  23. INSERT INTO S1 VALUES (22, 'zoe', 7, 45);
  24. INSERT INTO S1 VALUES (31, 'hal', 8, 55);
  25. INSERT INTO S1 VALUES (58, 'sam', 10, 35);
  26.  
  27. INSERT INTO S2 VALUES (28, 'ann', 8, 35);
  28. INSERT INTO S2 VALUES (31, 'hal', 8, 55);
  29. INSERT INTO S2 VALUES (44, 'jed', 5, 35);
  30. INSERT INTO S2 VALUES (58, 'sam', 10, 35);
  31.  
  32. INSERT INTO R1 VALUES (22, 101, 10/10/2013);
  33. INSERT INTO R1 VALUES (59, 103, 11/12/2013);
Success #stdin #stdout #stderr 0s 3448KB
stdin
Standard input is empty
stdout
Standard output is empty
stderr
Error: near line 17: near ")": syntax error
Error: near line 32: no such table: R1
Error: near line 33: no such table: R1