· 7 years ago · Dec 03, 2018, 03:16 PM
1CREATE TABLE IF NOT EXISTS list_kenalan(
2ID int (10) NOT NULL AUTO_INCREMENT,
3Fullname VARCHAR (50) NOT NULL,
4Address VARCHAR (50) NOT NULL,
5Contact_No int (50) NOT NULL,
6PRIMARY KEY (ID)
7) ENGINE = MyISAM DEFAULT CHARSET = utf8;
8
9
10INSERT INTO list_kenalan( Fullname, Address, Contact_No)
11VALUES
12( 'Hayati', 'Jakarta', '0852 6077 1012'),
13(' Adam ', 'Medan', '0811 1212 123'),
14(' Eva', 'Bali', '0852 6073 1010'),
15( 'Joni', 'Kalimantan', '0852 6007 5656'),
16(' Maya','Ciamis','0852 6097 1912'),
17('Diana', 'Bandung', '0854 1077 1012');