[Cassila4Sec]

SAMPLE

DROP TABLE IF EXISTS umkm_sleman;

CREATE TABLE umkm_sleman (
  no INT PRIMARY KEY,
  nik VARCHAR(16) NOT NULL,
  nama VARCHAR(150) NOT NULL,
  nama_usaha VARCHAR(150),
  tempat_usaha TEXT,
  no_telpon VARCHAR(30),
  INDEX idx_nik (nik),
  INDEX idx_nama_usaha (nama_usaha)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO umkm_sleman (no, nik, nama, nama_usaha, tempat_usaha, no_telpon) VALUES
(1, '3404125306860005', 'Nanik Lilis
Setyowati', 'Atk Family', 'Drono RT 03 / RW 33 Sardonoharjo,
NgaglikSleman', '081228522235'),
(2, '3404061909680005', 'PURWANTO', 'ANSALNI', 'Prumpung rt 003rw 028 sardonoharjo ngaglik
sleman jogjakarta', '082136002998'),
(3, '3404102805850002', 'Ardhian Surya', 'Joglo Bakso Pikul
Enak', 'Banglen', '085643005200'),
(4, '3404050210760006', 'MARYUNI', 'Rosse bambu', 'Gentan RT 05 RW 19 Margoagung seyegan', '085951655156'),
(5, '3404072404680004', 'Mizani', 'OAK LEATHER
GALLERY', 'Jl Bougenville No 1C, Santren, Caturtunggal', '087801000800'),
(6, '3404116912670002', 'IR MARIA SUSANA
HARTANTI', 'Giriwangi', 'Perumahan Mitra Griya Asri Blok A/4, Rt.10/rw.69,
Pucanganom, Wedomartani Ngemplak', '082136679598'),
(7, '3515185606780008', 'INDAH YUNIATUN', 'Dapur SIP Spesial
ikan asap', 'Perum Kepuh permai blok 2 A45 wwdomartani
Ngemplak Sleman.', '081578900018'),
(8, '3471015706760003', 'Silvia Dewi
Styaningrum', 'DnB Indonesia', 'Jl Anggrek No 750 Pogunglor Sinduadi Mlati
Sleman', '081325115311'),
(9, '3404025805800004', 'Yustina Ismiyati', 'YUSTIN''S
KITCHEN', 'Kowanan RT03 RW11, Kel. Sidoagung, Kec.
Godean, Kab. Sleman,Prov. Daerah Istimewa
Yogyakarta', '087839372662'),
(10, '3401121908790001', 'Robaeli Ndruru', 'MSTECH ORGANIK', 'MSTECH ORGANIK Jl. Kaliurang KM 19 Pakem
Sleman', '081215607921'),
(11, '3404072404880003', 'Angga Kusuma
Arybowo', 'Jadah Tempe Mbah
Carik (palagan)', 'JL Palagan KM 16, GLondong, Purwobinangun,
Pakem, Sleman', '81904900009'),
(12, '3404106810740004', 'AGUS PURWANTO/
RETY ASTUTI', 'Mountain White', 'Keniten rt 04/01 tamanmartani kalasan sleman', '081227898242'),
(13, '1401064711920003', 'Nurul Maulidiya', 'Dreampuff-Premium
Creame Puff and
More', 'Jalan Kaliurang Km.5', '082285700063'),
(14, '3404116209680002', 'DYAH WIDURI
SULAKSINTO', 'Kopi Jawa Gunung
Merak', 'Umbulmartani Ngemplak', '027489560408525348'),
(15, '3404122709740005', 'WIJANGSOKNO', 'JAYANTI
COLLECTION', 'SARIHARJO NGAGLIK', '0274867085'),
(16, '1504051605920001', 'ADI JETENDRA', 'Kebab Turkiyem', 'Sintokan,Wukirsari,Cangkringan,Sleman,DIY', '08990633722'),
(17, '3471026107950001', 'Afifah Dian Kusuma', 'Babybreath', 'Perumahan patukan indah 47 02/20
ambarketawang gamping sleman yogyakarta', '0895391621392'),
(18, '3301125904940004', 'Kurnia Fatmasari', '19 Laundry Bar', 'Jl perumnas C-04, Ngropoh, Condongcatur, Depok,
Sleman', '081282483329'),
(19, '3404134705600001', 'Sri Widayati', 'UD. Surya abadi', 'Beran Lor, RT 03/RW 21', '087745478898'),
(20, '3404011004850005', 'Sus Handoyo', 'VIFAS BATIK', 'Kebonagung Rt/w 01/30 Tridadi, Sleman, Sleman,
Yogyakarta', '081227303021');

DOWNLOAD HERE :
https://www.mediafire.com/file/0ij8671up...M.zip/file




— Cassila4Sec