fork download
  1. CREATE TABLE IF NOT EXISTS student(
  2. NIM INT NOT NULL,
  3. Name VARCHAR(10) NOT NULL,
  4. City_address VARCHAR(20) NOT NULL,
  5. Age TINYINT NOT NULL,
  6. IPK DECIMAL (3,2),
  7. Departement VARCHAR (10)
  8. );
  9. INSERT INTO student
  10. (NIM, Name, City_address, Age, IPK, Departement)
  11. Values
  12. (12345, "Adi", "Jakarta", 17, 2.5, "Math"),
  13. (12346, "Ani", "Yogyakarta", 20, 2.1, "Math"),
  14. (12347, "Ari", "Surabaya", 18, 2.5, "Computer"),
  15. (12348, "Ali", "Banjarmasin",20,3.5,"Computer"),
  16. (12349, "Abi", "Medan",17,3.7,"Computer"),
  17. (12350, "Budi", "Jakarta",19,3.8,"Computer"),
  18. (12351, "Boni", "Yogyakarta",20,3.2,"Computer"),
  19. (12352, "Bobi", "Surabaya",17,2.7,"Computer"),
  20. (12353, "Beni", "Banjarmasin",18,2.3,"Computer"),
  21. (12354, "Cepi", "Jakarta",20,2.2,NULL),
  22. (12355, "Coni", "Yogyakarta",22,2.6,NULL),
  23. (12356, "Ceki", "Surabaya",21,2.5,NULL),
  24. (12357, "Dodi", "Jakarta",20,3.1,"Math"),
  25. (12358, "Didi", "Yogyakarta",19,3.2,"Physics"),
  26. (12359, "Deri", "Surabaya",19,3.3,"Physics"),
  27. (12360, "Eli", "Jakarta",20,2.9,"Physics"),
  28. (12361, "Endah", "Yogyakarta",18,2.8,"Physics"),
  29. (12362, "Feni", "Jakarta",17,2.7,NULL),
  30. (12363, "Farah", "Yogyakarta",18,3.5,NULL),
  31. (12364, "Fandi", "Surabaya",19,3.4,NULL);
  32. SELECT* FROM student
Success #stdin #stdout 0.02s 25896KB
stdin
Standard input is empty
stdout
CREATE TABLE IF NOT EXISTS student(
 NIM INT NOT NULL,
 Name VARCHAR(10) NOT NULL,
 City_address VARCHAR(20) NOT NULL,
 Age TINYINT NOT NULL,
 IPK DECIMAL (3,2),
 Departement VARCHAR (10)
 );
INSERT INTO student 
(NIM, Name, City_address, Age, IPK, Departement)
Values
(12345, "Adi", "Jakarta", 17, 2.5, "Math"),
(12346, "Ani", "Yogyakarta", 20, 2.1, "Math"),
(12347, "Ari", "Surabaya", 18, 2.5, "Computer"),
(12348, "Ali", "Banjarmasin",20,3.5,"Computer"),
(12349, "Abi", "Medan",17,3.7,"Computer"),
(12350, "Budi", "Jakarta",19,3.8,"Computer"),
(12351, "Boni", "Yogyakarta",20,3.2,"Computer"),
(12352, "Bobi", "Surabaya",17,2.7,"Computer"),
(12353, "Beni", "Banjarmasin",18,2.3,"Computer"),
(12354, "Cepi", "Jakarta",20,2.2,NULL),
(12355, "Coni", "Yogyakarta",22,2.6,NULL),
(12356, "Ceki", "Surabaya",21,2.5,NULL),
(12357, "Dodi", "Jakarta",20,3.1,"Math"),
(12358, "Didi", "Yogyakarta",19,3.2,"Physics"),
(12359, "Deri", "Surabaya",19,3.3,"Physics"),
(12360, "Eli", "Jakarta",20,2.9,"Physics"),
(12361, "Endah", "Yogyakarta",18,2.8,"Physics"),
(12362, "Feni", "Jakarta",17,2.7,NULL),
(12363, "Farah", "Yogyakarta",18,3.5,NULL),
(12364, "Fandi", "Surabaya",19,3.4,NULL);
SELECT* FROM student