jam

CREATE TABLE IF NOT EXISTS list_kenalan(
ID int (10) NOT NULL AUTO_INCREMENT,
Fullname VARCHAR (50) NOT NULL,
Address VARCHAR (50) NOT NULL,
Contact_No int (50) NOT NULL,
PRIMARY KEY (ID)
) ENGINE = MyISAM DEFAULT CHARSET = utf8;


INSERT INTO list_kenalan( Fullname, Address, Contact_No)
VALUES
( 'Hayati', 'Jakarta', '0852 6077 1012'),
(' Adam ', 'Medan', '0811 1212 123'),
(' Eva', 'Bali', '0852 6073 1010'),
( 'Joni', 'Kalimantan', '0852 6007 5656'),
(' Maya','Ciamis','0852 6097 1912'),
('Diana', 'Bandung', '0854 1077 1012');