Belajar Mysql

CREATE DATABASE dbbuku;
USE dbbuku;
CREATE TABLE tbpengarang(
    no INT (3) NOT NULL,
    nama VARCHAR (25) NOT NULL,
    alamat VARCHAR (60) NOT NULL,
    email VARCHAR (40),
    no_telepon VARCHAR (15),
    PRIMARY KEY (no)
);
INSERT INTO tbpengarang (no,nama,alamat,email,no_telepon) VALUES('1','Sugeng Fitriyadi','Pemalang','sugeng@yahoo.com','0811223344');
INSERT INTO tbpengarang (no,nama,alamat,email,no_telepon) VALUES('2','Didik K','Lampung','','081233446666');
INSERT INTO tbpengarang (no,nama,alamat,email,no_telepon) VALUES('3','Arief N','Riau','arief@yahoo.com','0816363636');
INSERT INTO tbpengarang (no,nama,alamat,email,no_telepon) VALUES('4','Mawardi','Medan','sugeng@yahoo.com','');
INSERT INTO tbpengarang (no,nama,alamat,email,no_telepon) VALUES('5','Reno Mariaci','tagel','','0817959595');
INSERT INTO tbpengarang (no,nama,alamat,email,no_telepon) VALUES('6','Bunafit Nugroho','Lampung','banufit@yahoo.com','081556677889');
INSERT INTO tbpengarang (no,nama,alamat,email,no_telepon) VALUES('7','Agung','Klaten','agung@yahoo.com','0811667788');
UPDATE tbpengarang SET email='didik@yahoo.com' WHERE no=2;
UPDATE tbpengarang SET no_telepon='02187867888' WHERE no=4;
SELECT * FROM tbpengarang;
DELETE FROM tbpengarang WHERE no=5;