Untuk uji cobanya saya menggunakan perintah MySQL berikut:
Buat databasenya terlebih dahulu:
CREATE DATABASE coba;
Pakai databasenya:
USE DATABASE coba;
CREATE TABLE `rc_organisasi` (
`id` int(11) NOT NULL,
`kdProviderBPJS` varchar(50) NOT NULL,
`kdpus` varchar(50) DEFAULT NULL,
`nmPuskes` varchar(50) DEFAULT NULL,
`status` varchar(50) DEFAULT NULL,
`alamat` varchar(255) DEFAULT NULL,
`kelurahan` varchar(50) DEFAULT NULL,
`kecamatan` varchar(50) DEFAULT NULL,
`kota` varchar(50) DEFAULT NULL,
`provinsi` varchar(50) DEFAULT NULL,
`kdpos` varchar(50) DEFAULT NULL,
`telp` varchar(50) DEFAULT NULL,
`fax` varchar(50) DEFAULT NULL,
`email` varchar(50) DEFAULT NULL,
`koordinat` varchar(100) DEFAULT NULL,
`ktWilayah` varchar(50) DEFAULT NULL,
`ktPenyelenggara` varchar(50) DEFAULT NULL,
`Jumlah_Pusban` int(11) NOT NULL,
`Kepala_Puskesmas` varchar(255) NOT NULL,
`NIP1` varchar(255) NOT NULL,
`Pengelola_Data` varchar(255) NOT NULL,
`NIP2` varchar(255) NOT NULL,
`Petugas_Surveilans` varchar(255) NOT NULL,
`NIP3` varchar(255) NOT NULL,
`pkm_luas_wil` varchar(50) NOT NULL,
`pkm_jml_penduduk` varchar(50) NOT NULL,
`pkm_jml_kel` varchar(50) NOT NULL,
`pkm_jml_kel_miskin` varchar(50) NOT NULL,
`pkm_jml_desa` varchar(50) NOT NULL,
`pkm_perumnas` varchar(50) NOT NULL,
`pkm_transmigrasi` varchar(50) NOT NULL,
`pkm_perkebunan` varchar(50) NOT NULL,
`pkm_nelayanan` varchar(50) NOT NULL,
`pkm_industri` varchar(50) NOT NULL,
`pkm_pariwisata` varchar(50) NOT NULL,
`pkm_kepulauan` varchar(50) NOT NULL,
`pkm_perbatasan` varchar(50) NOT NULL,
`pkm_jml_desa_aktif_pratama` varchar(50) NOT NULL,
`pkm_jml_desa_aktif_siaga_madya` varchar(50) NOT NULL,
`pkm_jml_desa_aktif_purnama` varchar(50) NOT NULL,
`pkm_jml_desa_aktif_siaga_mandiri` varchar(50) NOT NULL,
`pkm_rencana_lima_tahunan` varchar(50) NOT NULL,
`pkm_ruk` varchar(50) NOT NULL,
`pkm_rpk` varchar(50) NOT NULL,
`pkm_rpk_bulanan` varchar(50) NOT NULL,
`pkm_lokakarya_mini_bulanan` varchar(50) NOT NULL,
`pkm_lokakarya_mini_tribulanan` varchar(50) NOT NULL,
`pkm_pkp` varchar(50) NOT NULL,
`pkm_pkp_ditetapkan_dinas_kes_kota` varchar(50) NOT NULL,
`pkm_umpan_balik_dari_dinkes_kabupaten_yang_diterima_pusk` varchar(50) NOT NULL,
`pkm_pelayanan_promosi_kesehatan` varchar(50) NOT NULL,
`pkm_pelayanan_kesehatan_lingkungan` varchar(50) NOT NULL,
`pkm_pel_kes_ibu_anak_kb` varchar(50) NOT NULL,
`pkm_pelayanan_gizi` varchar(50) NOT NULL,
`pkm_pel_pencegahan_dan_pengendalian_penyakit` varchar(50) NOT NULL,
`pkm_pelayanan_kes_jiwa` varchar(50) NOT NULL,
`pkm_pel_kes_gigi_masy` varchar(50) NOT NULL,
`pkm_pel_kes_tradisional_komplementer` varchar(50) NOT NULL,
`pkm_usaha_kes_sekolah` varchar(50) NOT NULL,
`pkm_pel_kes_olah_raga` varchar(50) NOT NULL,
`pkm_pel_kes_indera` varchar(50) NOT NULL,
`pkm_pel_kes_lansia` varchar(50) NOT NULL,
`pkm_pel_kes_kerja` varchar(50) NOT NULL,
`pkm_pel_kes_haji` varchar(50) NOT NULL,
`pkm_poned` varchar(50) NOT NULL,
`pkm_pandu_ptm` varchar(50) NOT NULL,
`pkm_lainnya` varchar(50) NOT NULL,
`pkm_pel_pemeriksaan_umum` varchar(50) NOT NULL,
`pkm_pel_kes_gigi_dan_mulut` varchar(50) NOT NULL,
`pkm_pel_gawat_darurat` varchar(50) NOT NULL,
`pkm_pel_rawat_inap` varchar(50) NOT NULL,
`pkm_pel_satu_hari` varchar(50) NOT NULL,
`pkm_home_care` varchar(50) NOT NULL,
`pkm_pelayanan_kefarmasi` varchar(50) NOT NULL,
`pkm_pelayanan_keperawatan_kes_masy` varchar(50) NOT NULL,
`pkm_pelayanan_laboratorium` varchar(50) NOT NULL,
`pkm_pusk_blud` varchar(50) NOT NULL,
`pkm_akreditasi_nasional` varchar(50) NOT NULL,
`pkm_iso` varchar(50) NOT NULL,
`pkm_pusk_telah_kerjasama_dgn_bpjs` varchar(50) NOT NULL,
`pkm_besar_kapitasi_untk_pusk` varchar(50) NOT NULL,
`pkm_jum_peserta_jkn_terdaftar` varchar(50) NOT NULL,
`pkm_dana_kapitasi_yg_diterima_slma_1_th` varchar(50) NOT NULL,
`pkm_persen_alokasi_dana_kapitasi_jasa_pel_kes` varchar(50) NOT NULL,
`pkm_keg_biaya_kapitasi_dukungan_biaya_operasional_pel_kes` varchar(50) NOT NULL,
`pkm_klinik_pratama` varchar(50) NOT NULL,
`pkm_dokter_praktik_mandiri` varchar(50) NOT NULL,
`pkm_dokter_gigi_praktik_mandiri` varchar(50) NOT NULL,
`pkm_penerima_bantuan_iuran` varchar(50) NOT NULL,
`pkm_non_penerima_bantuan_iuran` varchar(50) NOT NULL,
`pkm_peserta_jamkesda` varchar(50) NOT NULL,
`pkm_peserta_asuransi_komersil` varchar(50) NOT NULL,
`pkm_tahun_dibangun` varchar(50) NOT NULL,
`pkm_luas_tanah_pusk` varchar(50) NOT NULL,
`pkm_sertifikat_tanah` varchar(50) NOT NULL,
`pkm_kepemilikan_tanah` varchar(50) NOT NULL,
`pkm_luas_lantai_dasar_bangunan` varchar(50) NOT NULL,
`pkm_luas_total_lantai_bangunan` varchar(50) NOT NULL,
`pkm_jum_tempat_tdr_perawatan_umum` varchar(50) NOT NULL,
`pkm_jum_tmp_tidur_perawatan_persalinan` varchar(50) NOT NULL,
`pkm_izin_penyelenggaraan_pusk_tgl` varchar(50) NOT NULL,
`pkm_izin_penyelenggaraan_pusk_no_sk` varchar(50) NOT NULL,
`pkm_izin_penyelenggaraan_pusk_oleh` varchar(50) NOT NULL,
`pkm_izin_penyelenggaraan_pusk_masa_berlaku` varchar(50) NOT NULL,
`pkm_registrasi_pusk_tanggal` varchar(50) NOT NULL,
`pkm_registrasi_pusk_no_sk` varchar(50) NOT NULL,
`pkm_akreditasi_pusk_tgl` varchar(50) NOT NULL,
`pkm_akreditasi_pusk_no_sk` varchar(50) NOT NULL,
`pkm_akreditasi_pusk_oleh` varchar(50) NOT NULL,
`pkm_akreditasi_pusk_masa_berlaku` varchar(50) NOT NULL,
`pkm_jrk_pemukiman_terjauh_ke_pusk` varchar(50) NOT NULL,
`pkm_waktu_tempuh_terlama_bagi_warga_menuju_pusk` varchar(50) NOT NULL,
`pkm_akses_jln_dpn_gedung_pusk` varchar(50) NOT NULL,
`pkm_status_jln_raya_terdekat_menuju_ke_pusk` varchar(50) NOT NULL,
`pkm_th_terakhir_pusk_direhabilitasi` varchar(50) NOT NULL,
`pkm_ktpenyelenggara` varchar(50) NOT NULL,
`pkm_keadaan_bangunan_pusk` varchar(50) NOT NULL,
`pkm_pp_baik` varchar(50) NOT NULL,
`pkm_pp_rusak_ringan` varchar(50) NOT NULL,
`pkm_pp_rusak_sedang` varchar(50) NOT NULL,
`pkm_pp_rusak_berat` varchar(50) NOT NULL,
`pkm_bangunan_rumah_dinas_tenaga_kesh_baik` varchar(50) NOT NULL,
`pkm_bangunan_rumah_dinas_tenaga_keshrusak_ringan` varchar(50) NOT NULL,
`pkm_bangunan_rumah_dinas_tenaga_kesh_rusak_sedang` varchar(50) NOT NULL,
`pkm_bangunan_rumah_dinas_tenaga_kesh_rusak_berat` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_1` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_1` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_1` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_1` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_2` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_2` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_2` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_2` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_3` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_3` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_3` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_3` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_4` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_4` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_4` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_4` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_5` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_5` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_5` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_5` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_6` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_6` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_6` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_6` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_7` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_7` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_7` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_7` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_8` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_8` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_8` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_8` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_9` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_9` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_9` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_9` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_10` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_10` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_10` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_10` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_11` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_11` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_11` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_11` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_12` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_12` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_12` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_12` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_13` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_13` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_13` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_13` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_14` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_14` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_14` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_14` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_15` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_15` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_15` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_15` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_16` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_16` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_16` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_16` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_17` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_17` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_17` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_17` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_18` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_18` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_18` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_18` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_19` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_19` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_19` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_19` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_20` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_20` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_20` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_20` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_21` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_21` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_21` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_21` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_22` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_22` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_22` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_22` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_23` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_23` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_23` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_23` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_24` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_24` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_24` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_24` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_25` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_25` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_25` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_25` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_26` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_26` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_26` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_26` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_27` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_27` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_27` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_27` varchar(50) NOT NULL,
`pkm_rpelayanan_tersedia_28` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_pendirian_28` varchar(50) NOT NULL,
`pkm_rpelayanan_thn_renovasi_28` varchar(50) NOT NULL,
`pkm_rpelayanan_kondisi_28` varchar(50) NOT NULL,
`pkm_rkantor_tersedia_1` varchar(50) NOT NULL,
`pkm_rkantor_thn_pendirian_1` varchar(50) NOT NULL,
`pkm_rkantor_thn_renovasi_1` varchar(50) NOT NULL,
`pkm_rkantor_kondisi_1` varchar(50) NOT NULL,
`pkm_rkantor_tersedia_2` varchar(50) NOT NULL,
`pkm_rkantor_thn_pendirian_2` varchar(50) NOT NULL,
`pkm_rkantor_thn_renovasi_2` varchar(50) NOT NULL,
`pkm_rkantor_kondisi_2` varchar(50) NOT NULL,
`pkm_rkantor_tersedia_3` varchar(50) NOT NULL,
`pkm_rkantor_thn_pendirian_3` varchar(50) NOT NULL,
`pkm_rkantor_thn_renovasi_3` varchar(50) NOT NULL,
`pkm_rkantor_kondisi_3` varchar(50) NOT NULL,
`pkm_rkantor_tersedia_4` varchar(50) NOT NULL,
`pkm_rkantor_thn_pendirian_4` varchar(50) NOT NULL,
`pkm_rkantor_thn_renovasi_4` varchar(50) NOT NULL,
`pkm_rkantor_kondisi_4` varchar(50) NOT NULL,
`pkm_rkantor_tersedia_5` varchar(50) NOT NULL,
`pkm_rkantor_thn_pendirian_5` varchar(50) NOT NULL,
`pkm_rkantor_thn_renovasi_5` varchar(50) NOT NULL,
`pkm_rkantor_kondisi_5` varchar(50) NOT NULL,
`pkm_rpendukung_tersedia_1` varchar(50) NOT NULL,
`pkm_rpendukung_thn_pendirian_1` varchar(50) NOT NULL,
`pkm_rpendukung_thn_renovasi_1` varchar(50) NOT NULL,
`pkm_rpendukung_kondisi_1` varchar(50) NOT NULL,
`pkm_rpendukung_tersedia_2` varchar(50) NOT NULL,
`pkm_rpendukung_thn_pendirian_2` varchar(50) NOT NULL,
`pkm_rpendukung_thn_renovasi_2` varchar(50) NOT NULL,
`pkm_rpendukung_kondisi_2` varchar(50) NOT NULL,
`pkm_rpendukung_tersedia_3` varchar(50) NOT NULL,
`pkm_rpendukung_thn_pendirian_3` varchar(50) NOT NULL,
`pkm_rpendukung_thn_renovasi_3` varchar(50) NOT NULL,
`pkm_rpendukung_kondisi_3` varchar(50) NOT NULL,
`pkm_rpendukung_tersedia_4` varchar(50) NOT NULL,
`pkm_rpendukung_thn_pendirian_4` varchar(50) NOT NULL,
`pkm_rpendukung_thn_renovasi_4` varchar(50) NOT NULL,
`pkm_rpendukung_kondisi_4` varchar(50) NOT NULL,
`pkm_waktu_ketersediaan_listrik` varchar(50) NOT NULL,
`pkm_daya_listrik_terpasang` varchar(50) NOT NULL,
`pkm_jum_genset_yg_berfungsi` varchar(50) NOT NULL,
`pkm_kapasitas_genset_yg_berfungsi` varchar(50) NOT NULL,
`pkm_telepon_kabel` varchar(50) NOT NULL,
`pkm_telepon_seluler` varchar(50) NOT NULL,
`pkm_radio_komunikasi` varchar(50) NOT NULL,
`pkm_alat_komunikasi_lain` varchar(50) NOT NULL,
`pkm_jaringan_internet` varchar(50) NOT NULL,
`pkm_jml_kesling_roda_4_dbl_gardan_baik` varchar(50) NOT NULL,
`pkm_jml_kesling_roda_4_dbl_gardan_rusak_ringan` varchar(50) NOT NULL,
`pkm_jml_kesling_roda_4_dbl_gardan_rusak_berat` varchar(50) NOT NULL,
`pkm_jml_kesling_roda_4_single_gardan_baik` varchar(50) NOT NULL,
`pkm_jml_kesling_roda_4_single_gardan_rusak_ringan` varchar(50) NOT NULL,
`pkm_jml_kesling_roda_4_single_gardan_rusak_berat` varchar(50) NOT NULL,
`pkm_jml_kesling_perairan_baik` varchar(50) NOT NULL,
`pkm_jml_kesling_perairan_rusak_ringan` varchar(50) NOT NULL,
`pkm_jml_kesling_perairan_rusak_berat` varchar(50) NOT NULL,
`pkm_jml_sepeda_motor_baik` varchar(50) NOT NULL,
`pkm_jml_sepeda_motor_rusak_ringan` varchar(50) NOT NULL,
`pkm_jml_sepeda_motor_rusak_berat` varchar(50) NOT NULL,
`pkm_jml_sepeda_baik` varchar(50) NOT NULL,
`pkm_jml_sepeda_rusak_ringan` varchar(50) NOT NULL,
`pkm_jml_sepeda_rusak_berat` varchar(50) NOT NULL,
`pkm_kendaraan_ambulan_baik` varchar(50) NOT NULL,
`pkm_kendaraan_ambulan_rusak_ringan` varchar(50) NOT NULL,
`pkm_kendaraan_ambulan_rusak_berat` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_puskesmas_air_bersih` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_air_bersih_24_jam` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_sumber_air_bersih` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_jamban` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_sarana_pengelolaan_limbah` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_sarana_pengelolaan_limbah_padat` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_sarana_pengelolaan_limbah_cair` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_sarana_pengelolaan_limbah_septiktank` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_mou_limbah_padat_b3_ke_pihak_berijin` varchar(50) NOT NULL,
`pkm_sistem_sanitasi_mou_limbah_cair_ke_pihak_berijin` varchar(50) NOT NULL,
`pkm_sistem_gas_medik_jml_berfungsi` varchar(50) NOT NULL,
`pkm_sistem_gas_medik_jml_oksigen_konsentrator_berfungsi` varchar(50) NOT NULL,
`pkm_sistem_gas_medik_jml_oksigen_konsentrator_tidak_berfungsi` varchar(50) NOT NULL,
`pkm_jml_alat_pemadam_kebakaran_berfungsi` varchar(50) NOT NULL,
`pkm_jml_alat_pemadam_kebakaran_tidak_berfungsi` varchar(50) NOT NULL,
`pkm_sistem_proteksi_petir` varchar(50) NOT NULL,
`pkm_jml_ac_berfungsi` varchar(50) NOT NULL,
`pkm_jml_ac__tidak_berfungsi` varchar(50) NOT NULL,
`jml_puskesmas_pembantu` varchar(50) NOT NULL,
`jml_bidan_desa` varchar(50) NOT NULL,
`kesling` varchar(50) NOT NULL,
`jml_klinik_pratama` varchar(50) NOT NULL,
`jml_klinik_utama` varchar(50) NOT NULL,
`jml_dokter_praktik_mandiri` varchar(50) NOT NULL,
`jml_dokter_gigi_praktik_mandiri` varchar(50) NOT NULL,
`jml_bidan_praktik_swasta` varchar(50) NOT NULL,
`jml_perawat_praktik_mandiri` varchar(50) NOT NULL,
`jml_rumah_sakit_kelas_D_pratama` varchar(50) NOT NULL,
`jml_apotek` varchar(50) NOT NULL,
`jml_optik` varchar(50) NOT NULL,
`jml_laboratorium_klinik` varchar(50) NOT NULL,
`program_kerjasama_rs_darah` varchar(50) NOT NULL,
`jml_rutan_lapas` varchar(50) NOT NULL,
`posyandu_pratama` varchar(50) NOT NULL,
`posyandu_madya` varchar(50) NOT NULL,
`posyandu_purnama` varchar(50) NOT NULL,
`posyandu_mandiri` varchar(50) NOT NULL,
`posyandu_lansia` varchar(50) NOT NULL,
`jml_poskesdes` varchar(50) NOT NULL,
`jml_poskestren` varchar(50) NOT NULL,
`jml_posbindu_ptm_aktif` varchar(50) NOT NULL,
`jml_desa_posbindu_ptm_aktif` varchar(50) NOT NULL,
`jml_pos_tb_desa_aktif` varchar(50) NOT NULL,
`jml_posmaldes_aktif` varchar(50) NOT NULL,
`pos_ukk_pratama` varchar(50) NOT NULL,
`pos_ukk_madya` varchar(50) NOT NULL,
`pos_ukk_purnama` varchar(50) NOT NULL,
`pos_ukk_mandiri` varchar(50) NOT NULL,
`jml_pod` varchar(50) NOT NULL,
`jml_polindes` varchar(50) NOT NULL,
`jml_desa_kegiatan_dana_sehat` varchar(50) NOT NULL,
`jml_peserta_dana_sehat` varchar(50) NOT NULL,
`jml_ukbm_lainnya` varchar(50) NOT NULL,
`jml_kelompok_kerja_operasional_ukbm` varchar(50) NOT NULL,
`jml_pokjanal_posyandu` varchar(50) NOT NULL,
`jml_forum_peduli_kesehatan` varchar(50) NOT NULL,
`jml_forum_desa_siaga_buah_aktif` varchar(50) NOT NULL,
`kader_posyandu` varchar(50) NOT NULL,
`kader_poskesdes` varchar(50) NOT NULL,
`kader_poskestren` varchar(50) NOT NULL,
`petugas_pelaksana_posbindu_ptm` varchar(50) NOT NULL,
`kader_pos_tb_desa` varchar(50) NOT NULL,
`kader_posmaldes` varchar(50) NOT NULL,
`kader_pos_ukk` varchar(50) NOT NULL,
`kader_desa_siaga_aktif` varchar(50) NOT NULL,
`organisasi_kemasyarakatan` varchar(50) NOT NULL,
`dunia_usaha` varchar(50) NOT NULL,
`ingo` varchar(50) NOT NULL,
`mitra_lainnya` varchar(50) NOT NULL,
`jml_kebijakan_publik_berwawasan_kesehatan` varchar(50) NOT NULL,
`puskesmas_wahana_pendidikan_tenaga` varchar(50) NOT NULL,
`pelayanan_kesehatan_begerak` varchar(50) NOT NULL,
`jml_sd` varchar(50) NOT NULL,
`jml_sltp` varchar(50) NOT NULL,
`jml_slta` varchar(50) NOT NULL,
`nik` varchar(50) NOT NULL,
`nip_nrp` varchar(50) NOT NULL,
`no_seri_kartu_pegawai` varchar(50) NOT NULL,
`nama_lengkap` varchar(50) NOT NULL,
`gelar_depan_nama` varchar(50) NOT NULL,
`gelar_belakang_nama` varchar(50) NOT NULL,
`jenis_kelamin` varchar(50) NOT NULL,
`tempat_lahir` varchar(50) NOT NULL,
`tanggal_lahir` varchar(50) NOT NULL,
`agama` varchar(50) NOT NULL,
`status_perkawinan` varchar(50) NOT NULL,
`alamat_email` varchar(50) NOT NULL,
`telp_hp` varchar(50) NOT NULL,
`tanggal_berlaku_str` varchar(50) NOT NULL,
`tanggal_berlaku_stp` varchar(50) NOT NULL,
`tanggal_berlaku_sik` varchar(50) NOT NULL,
`status_kepegawaian` varchar(50) NOT NULL,
`tmt_CPNS` varchar(50) NOT NULL,
`tmt_PNS` varchar(50) NOT NULL,
`tanggal_mulai_melaksanakan_tugas` varchar(50) NOT NULL,
`tanggal_berakhir_melaksanakan_tugas` varchar(50) NOT NULL,
`pendidikan_waktu_pengangkatan_pertama` varchar(50) NOT NULL,
`kode_sdmk` varchar(50) NOT NULL,
`pendidikan_tertinggi_saat_ini` varchar(50) NOT NULL,
`instansi_induk` varchar(50) NOT NULL,
`jenis_kepegawaian` varchar(50) NOT NULL,
`golongan_terakhir` varchar(50) NOT NULL,
`tmt_golongan` varchar(50) NOT NULL,
`masa_kerja_golongan` varchar(50) NOT NULL,
`nama_tempat_bekerja_sekarang` varchar(50) NOT NULL,
`nama_unit_kerja` varchar(50) NOT NULL,
`tanggal_mulai_tugas_unit_kerja` varchar(50) NOT NULL,
`desa_kelurahan` varchar(50) NOT NULL,
`kabupaten_kota` varchar(50) NOT NULL,
`chk_lokasi_gdg` varchar(50) NOT NULL,
`chk_kendaraan_jalan` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Lihat, tabel yang saya buat mempunyai kolom yang sangat banyak. Ketika saya melakukan impor dengan versi yang sama (5.5 ke 5.5) tidak jadi masalah, tapi ketika saya impor ke versi yang lebih baru (5.5 ke 5.7). Error tersebut kemudian muncul dan membuat proses impor gagal. Dan errornya pada pembuatan tabel tersebut.
Oke, akhirnya saya browsing-browsing dan ketemu penyelesaiannya. Ternyata permasalahan ada pada fitur keamanan dari MySQL versi 5.7 dimana variabel innodb_strict_mode masih ON. Cara melihatnya masih aktif atau tidak bisa menggunakan perintah MySQL berikut:
show variables like '%strict%';
 |
| innodb_strict_mode : ON |
Untuk menonaktifkannya, gunakan perintah MySQL berikut:
set innodb_strict_mode = 'OFF';
 |
| perintah MySQL untuk menon-aktifkan innodb_strict_mode |
 |
| innodb_strict_mode : OFF |
Lalu silakan coba ulangi membuat tabel tersebut. Taraaa, akhirnya sukses kan. Alhamdulillah.
Jika ada yang masih mengalami error silakan edit file my.cfg (linux) atau file my.ini (windows), tambahkan script berikut:
[mysqld]
max_allowed_packet = 1G
innodb_log_file_size = 2G
innodb_log_buffer_size = 512M
innodb_file_per_table
innodb_file_format = Barracuda
 |
| setting di my.cfg / my.ini |
Semoga membantu.
Salam.
0 Response to "[SOLVED] MySQL : ERROR 1118 (42000) at line 640135: Row size too large (> 8126)"
Posting Komentar