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
Q1JFQVRFIFRBQkxFIElGIE5PVCBFWElTVFMgc3R1ZGVudCgKIE5JTSBJTlQgTk9UIE5VTEwsCiBOYW1lIFZBUkNIQVIoMTApIE5PVCBOVUxMLAogQ2l0eV9hZGRyZXNzIFZBUkNIQVIoMjApIE5PVCBOVUxMLAogQWdlIFRJTllJTlQgTk9UIE5VTEwsCiBJUEsgREVDSU1BTCAoMywyKSwKIERlcGFydGVtZW50IFZBUkNIQVIgKDEwKQogKTsKSU5TRVJUIElOVE8gc3R1ZGVudCAKKE5JTSwgTmFtZSwgQ2l0eV9hZGRyZXNzLCBBZ2UsIElQSywgRGVwYXJ0ZW1lbnQpClZhbHVlcwooMTIzNDUsICJBZGkiLCAiSmFrYXJ0YSIsIDE3LCAyLjUsICJNYXRoIiksCigxMjM0NiwgIkFuaSIsICJZb2d5YWthcnRhIiwgMjAsIDIuMSwgIk1hdGgiKSwKKDEyMzQ3LCAiQXJpIiwgIlN1cmFiYXlhIiwgMTgsIDIuNSwgIkNvbXB1dGVyIiksCigxMjM0OCwgIkFsaSIsICJCYW5qYXJtYXNpbiIsMjAsMy41LCJDb21wdXRlciIpLAooMTIzNDksICJBYmkiLCAiTWVkYW4iLDE3LDMuNywiQ29tcHV0ZXIiKSwKKDEyMzUwLCAiQnVkaSIsICJKYWthcnRhIiwxOSwzLjgsIkNvbXB1dGVyIiksCigxMjM1MSwgIkJvbmkiLCAiWW9neWFrYXJ0YSIsMjAsMy4yLCJDb21wdXRlciIpLAooMTIzNTIsICJCb2JpIiwgIlN1cmFiYXlhIiwxNywyLjcsIkNvbXB1dGVyIiksCigxMjM1MywgIkJlbmkiLCAiQmFuamFybWFzaW4iLDE4LDIuMywiQ29tcHV0ZXIiKSwKKDEyMzU0LCAiQ2VwaSIsICJKYWthcnRhIiwyMCwyLjIsTlVMTCksCigxMjM1NSwgIkNvbmkiLCAiWW9neWFrYXJ0YSIsMjIsMi42LE5VTEwpLAooMTIzNTYsICJDZWtpIiwgIlN1cmFiYXlhIiwyMSwyLjUsTlVMTCksCigxMjM1NywgIkRvZGkiLCAiSmFrYXJ0YSIsMjAsMy4xLCJNYXRoIiksCigxMjM1OCwgIkRpZGkiLCAiWW9neWFrYXJ0YSIsMTksMy4yLCJQaHlzaWNzIiksCigxMjM1OSwgIkRlcmkiLCAiU3VyYWJheWEiLDE5LDMuMywiUGh5c2ljcyIpLAooMTIzNjAsICJFbGkiLCAiSmFrYXJ0YSIsMjAsMi45LCJQaHlzaWNzIiksCigxMjM2MSwgIkVuZGFoIiwgIllvZ3lha2FydGEiLDE4LDIuOCwiUGh5c2ljcyIpLAooMTIzNjIsICJGZW5pIiwgIkpha2FydGEiLDE3LDIuNyxOVUxMKSwKKDEyMzYzLCAiRmFyYWgiLCAiWW9neWFrYXJ0YSIsMTgsMy41LE5VTEwpLAooMTIzNjQsICJGYW5kaSIsICJTdXJhYmF5YSIsMTksMy40LE5VTEwpOwpTRUxFQ1QqIEZST00gc3R1ZGVudA==
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