guii

CREATE TABLE `list_kenalan` (
  `ID` int(10) NOT NULL,
  `Fullname` varchar(50) NOT NULL,
  `Address` varchar(50) NOT NULL,
  `Contact_No` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

ALTER TABLE `list_kenalan`
  ADD PRIMARY KEY (`ID`);