- Joined
- Jun 14, 2024
- Messages
- 2,601
- Reaction score
- 24,202
- Points
- 113
- Thread Author
- #1
nec-oman.com
nec-oman.com dumpdate 2022-03 format: sql all rows: 3758417 size: 1Gb
Sample
Code:
INSERT INTO `user` ( `id` , `dep` , `uid` , `ar` , `firstName` , `lastName` , `usertype` , `nmp` , `username` , `password` , `chuser` , `userEmail` , `gender` , `contactNumber` , `ph2` , `log` , `status` ) VALUES ( 2 , '' , 0 , 'ADAM' , ' SYSTEM' , 'Admin' , 1 , 'N' , 'admin' , 'admin1234' , 'admin' , '' , '' , '' , '' , 'Y' , 'Y' ), ( 15 , 'E' , 2 , 'AL ASHKHARAH' , ' DAKHLIYA LINEMAN 1' , '' , 4 , 'O' , 'dk1' , '123' , 'dk1' , '' , '' , '' , '' , 'Y' , 'Y' ), ( 137 , '' , 12 , 'AL AWABI' , ' AWABI' , NULL , 4 , 'O' , 'rs3' , '123' , 'rs3' , NULL , NULL , '' , '' , 'Y' , 'Y' ), ( 99 , 'E' , 2 , 'NIZWA' , ' DAKHLIYA LINEMAN 2' , '' , 4 , 'O' , 'dk2' , '123' , 'dk2' , '' , '' , '71112280' , '' , 'Y' , 'Y' ), ( 365 , '' , 14 , 'J.B.B.HASSAN' , ' AHMED ALMSHARFI' , NULL , 4 , 'O' , '1796' , '1234' , '1796' , NULL , NULL , '96992243' , '' , 'Y' , 'Y' ), ( 127 , 'W' , 0 , '0' , ' PAW USER' , NULL , 6 , 'O' , 'paw1' , '123' , 'paw1' , NULL , NULL , '' , '' , 'Y' , 'Y' ), ( 128 , '' , 12 , 'AL HUQAIN' , ' HAUQAIN' , NULL , 4 , 'O' , 'rs1' , '123' , 'rs1' , NULL , NULL , '' , '' , 'Y' , 'Y' ), ( 425 , 'E' , 2 , 'NIZWA' , ' ABDA MALAK' , NULL , 10 , 'O' , '1866' , '1234' , '1866' , NULL , NULL , '92463427' , '' , 'Y' , 'Y' ), ( 141 , '' , 12 , 'RUSTAQ' , ' RUSTAQ' , NULL , 4 , 'O' , 'rs4' , '123' , 'rs4' , NULL , NULL , '' , '' , 'Y' , 'Y' ), ( 139 , '' , 12 , 'RUSTAQ' , ' RUSTAQ' , NULL , 4 , 'O' , 'rs2' , '123' , 'rs2' , NULL , NULL , '' , '' , 'Y' , 'Y' ), ( 140 , '' , 12 , 'RUSTAQ' , ' RUSTAQ 5' , NULL , 4 , 'O' , 'rs5' , '123' , 'rs5' , NULL , NULL , '' , '' , 'Y' , 'Y' ), ( '01221561' , '60999936' , '1221' , 'E' , '?…?¨?§?±?ƒ ?®?…???³ ?¹?¨?¯?§?„?„?‡ ?§?„?¹?„?ˆ?? - MUBARAK KHAMIS ABDULLAH AL ALAWI' , 'Private' , '99318082' , '59.50881385' , '22.58301232' , 'Commercial' , '793.3636' , 'South Sharqiyyah' , '?µ?ˆ?± - Sur' , '1 PH\r' , NULL , NULL , NULL , NULL , NULL , NULL , '202008' ), ( '01221561' , '?…?¨?§?±?ƒ ?®?…???³ ?¹?¨?¯?§?„?„?‡ ?§?„?¹?„?ˆ?? - MUBARAK KHAMIS ABDULLAH AL ALAWI' , '4/8/2012' , 'Active/Normal' , 'Private' , 'Commercial' , 'South Sharqiyyah' , '?µ?ˆ?± - Sur' , '99318082' , '59.50881385' , '22.58301232' , '60999936' , '1 PH' , 'Analog' , '12264' , '8/17/2020' , 'MREAD' , NULL , '1221' , '14.1818' , '202009' ), ( '01221562' , '60999937' , '1221' , 'E' , '?…?¨?§?±?ƒ ?®?…???³ ?¹?¨?¯?§?„?„?‡ ?§?„?¹?„?ˆ?? - MUBARAK KHAMIS ABDULLAH AL ALAWI' , 'Private' , '99318082' , '59.50881385' , '22.58301232' , 'Commercial' , '532.2727' , 'South Sharqiyyah' , '?µ?ˆ?± - Sur' , '1 PH\r' , NULL , NULL , NULL , NULL , NULL , NULL , '202008' ), ( '01221562' , '?…?¨?§?±?ƒ ?®?…???³ ?¹?¨?¯?§?„?„?‡ ?§?„?¹?„?ˆ?? - MUBARAK KHAMIS ABDULLAH AL ALAWI' , '4/8/2012' , 'Active/Normal' , 'Private' , 'Commercial' , 'South Sharqiyyah' , '?µ?ˆ?± - Sur' , '99318082' , '59.50881385' , '22.58301232' , '60999937' , '1 PH' , 'Analog' , '27592' , '8/17/2020' , 'MREAD' , NULL , '1221' , '330.7273' , '202009' ), ( '01220491' , '?…?¨?§?±?ƒ ?®?…???³ ?¹?¨?¯?§?„?„?‡ ?§?„?¹?„?ˆ?? - MUBARK KHAMIS ABDULLAH AL ALWI' , '30/03/2011' , 'Active/Normal' , 'Private' , 'Commercial' , 'South Sharqiyyah' , '?µ?ˆ?± - Sur' , '99318082' , '59.50532642' , '22.571932' , '60564654' , '1 PH' , 'Analog' , '18018' , '15/11/2020' , 'MREAD' , '' , '1221' , '142\r' , '202012' ), ( '01220492' , '?…?¨?§?±?ƒ ?®?…???³ ?¹?¨?¯?§?„?„?‡ ?§?„?¹?„?ˆ?? - MUBARK KHAMIS ABDULLAH AL ALWI' , '30/03/2011' , 'Active/Normal' , 'Private' , 'Commercial' , 'South Sharqiyyah' , '?µ?ˆ?± - Sur' , '99318082' , '59.50532642' , '22.571932' , '60564652' , '1 PH' , 'Analog' , '21902' , '15/11/2020' , 'MREAD' , '' , '1221' , '238.7273\r' , '202012' ), INSERT INTO `customerlist` ( `id` , `cons_acno` , `pid` , `region` , `district` , `area` , `cons_met_num` , `cons_met_siz` , `disc_req` , `cons_discntyp` , `cons_name` , `cons_gsm` , `cons_codrn_lat` , `cons_codrn_lon` , `cons_geo` , `cons_outstnd` , `device_id` , `discon` , `infotime` , `receipt` , `rof` , `commnts` , `recon_stat` , `recon_time` , `empid` , `machine_code` , `updt` , `regdt` , `con_add` ) VALUES ( 99992 , 1221561 , 0 , 'SOUTH SHARQIYYAH' , 'SOUTH SHARQIYYAH' , 'SUR' , '60999936' , '' , '' , '' , '?“â„¢?’?ƒ?“â„¢?²?‚???“?’?‡ ?“?’â„–?“?’???“?’?‡?“?’?§?“â„¢?²?‚?›?“â„¢?²?‚?›?“â„¢?²?‚?? ?“â„¢?²?‚?¦?“?’?“â„¢?²?‚?¦?“?’?‡ ?“?’?§?“â„¢?²?‚?›?“?’?®?“?’?†?“?’?§?“â„¢?²?‚?¦' , 92427272 , '22.571932003' , '59.505326421' , '' , 0.000 , '' , 'NO' , '0000-00-00 00:00:00' , '' , '' , '' , 'N' , '0000-00-00 00:00:00' , '' , '' , '2022-02-14 18:50:48' , '2022-02-14 15:53:42' , '' ), ( 99993 , 1221562 , 0 , 'SOUTH SHARQIYYAH' , 'SOUTH SHARQIYYAH' , 'SUR' , '60999937' , '' , '' , '' , '?“â„¢?’?ƒ?“â„¢?²?‚???“?’?‡ ?“?’â„–?“?’???“?’?‡?“?’?§?“â„¢?²?‚?›?“â„¢?²?‚?›?“â„¢?²?‚?? ?“â„¢?²?‚?¦?“?’?“â„¢?²?‚?¦?“?’?‡ ?“?’?§?“â„¢?²?‚?›?“?’?®?“?’?†?“?’?§?“â„¢?²?‚?¦' , 92427272 , '22.571932003' , '59.505326421' , '' , 0.000 , '' , 'NO' , '0000-00-00 00:00:00' , '' , '' , '' , 'N' , '0000-00-00 00:00:00' , '' , '' , '2022-02-14 18:50:48' , '2022-02-14 15:53:42' , '' ), ( 99994 , 1221563 , 0 , 'SOUTH SHARQIYYAH' , 'SOUTH SHARQIYYAH' , 'SUR' , '22121078440283' , '' , '' , '' , '?“â„¢?²?‚?¦?“?’???“?’?§?“?’?±?“â„¢?–’ ?“?’?®?“â„¢?²?‚?¦?“â„¢?• ?“?’?– ?“?’â„–?“?’???“?’?‡?“?’?§?“â„¢?²?‚?›?“â„¢?²?‚?›?“â„¢?²?‚?? ?“?’?§?“â„¢?²?‚?›?“?’â„–?“â„¢?²?‚?›?“â„¢?›â€ ?“â„¢?• ' , 99318082 , '22.571932003' , '59.505326421' , '' , 0.000 , '' , 'NO' , '0000-00-00 00:00:00' , '' , '' , '' , 'N' , '0000-00-00 00:00:00' , '' , '' , '2022-02-14 18:50:49' , '2022-02-14 15:53:42' , '' ), ( 99995 , 1221564 , 0 , 'SOUTH SHARQIYYAH' , 'SOUTH SHARQIYYAH' , 'SUR' , '60999939' , '' , '' , '' , '?“â„¢?’?ƒ?“â„¢?²?‚???“?’?‡ ?“?’â„–?“?’???“?’?‡?“?’?§?“â„¢?²?‚?›?“â„¢?²?‚?›?“â„¢?²?‚?? ?“â„¢?²?‚?¦?“?’?“â„¢?²?‚?¦?“?’?‡ ?“?’?§?“â„¢?²?‚?›?“?’?®?“?’?†?“?’?§?“â„¢?²?‚?¦' , 92427272 , '22.571932003' , '59.505326421' , '' , 0.000 , '' , 'NO' , '0000-00-00 00:00:00' , '' , '' , '' , 'N' , '0000-00-00 00:00:00' , '' , '' , '2022-02-14 18:50:49' , '2022-02-14 15:53:42' , '' ), ( 99996 , 1221565 , 0 , 'SOUTH SHARQIYYAH' , 'SOUTH SHARQIYYAH' , 'SUR' , 'P19S3451' , '' , '' , '' , '?“â„¢?’?ƒ?“â„¢?²?‚???“?’?‡ ?“?’â„–?“?’???“?’?‡?“?’?§?“â„¢?²?‚?›?“â„¢?²?‚?›?“â„¢?²?‚?? ?“â„¢?²?‚?¦?“?’?“â„¢?²?‚?¦?“?’?‡ ?“?’?§?“â„¢?²?‚?›?“?’?®?“?’?†?“?’?§?“â„¢?²?‚?¦' , 92427272 , '22.571932003' , '59.505326421' , '' , 0.000 , '' , 'NO' , '0000-00-00 00:00:00' , '' , '' , '' , 'N' , '0000-00-00 00:00:00' , '' , '' , '2022-02-14 18:50:50' , '2022-02-14 15:53:42' , '' ), ( 99997 , 1221566 , 0 , 'SOUTH SHARQIYYAH' , 'SOUTH SHARQIYYAH' , 'SUR' , '22121078440572' , '' , '' , '' , '?“â„¢?’?ƒ?“â„¢?²?‚???“?’?‡ ?“?’â„–?“?’???“?’?‡?“?’?§?“â„¢?²?‚?›?“â„¢?²?‚?›?“â„¢?²?‚?? ?“â„¢?²?‚?¦?“?’?“â„¢?²?‚?¦?“?’?‡ ?“?’?§?“â„¢?²?‚?›?“?’?®?“?’?†?“?’?§?“â„¢?²?‚?¦' , 92427272 , '22.571932003' , '59.505326421' , '' , 0.000 , '' , 'NO' , '0000-00-00 00:00:00' , '' , '' , '' , 'N' , '0000-00-00 00:00:00' , '' , '' , '2022-02-14 18:50:51' , '2022-02-14 15:53:42' , '' ), INSERT INTO `disconliststat` ( `id` , `watel` , `cons_acno` , `pid` , `region` , `district` , `area` , `cons_met_num` , `cons_met_siz` , `tarif` , `disc_req` , `cons_discntyp` , `cons_name` , `cons_gsm` , `cons_codrn_lat` , `cons_codrn_lon` , `cons_geo` , `cons_outstnd` , `prty` , `upldate` , `device_id` , `discon` , `disconbill` , `discon_time` , `disd t` , `infodt` , `infotime` , `receipt` , `rof` , `rofbill` , `commnts` , `mlread` , `recon_stat` , `recon_time` , `vdiv` , `newlat` , `newlon` , `empid` , `mread` , `machine_code` , `updt` , `con_add` , `mdel` , `valdtd` , `valby` , `valon` , `valcomm` , `status` , `vstat` , `vdcfrom` , `vrsn` , `vdccom` , `valopclos` ) VALUES ( 3381 , 'E' , 1912379 , 0 , 'DAKHLIYA' , 'DAKHLIYA' , 'BAHLA ' , 'LG18CT42036993' , 'A_3PH' , '' , 'Non-Payment' , 'Pole' , '?™â€¦????™â€¦???¯ ???³???¹?™? ???¯' , 0 , '22.99101921' , '57.31331244' , '' , 2518.099 , 'High' , '0000-00-00' , '' , 'YES' , '' , '2020-08-10 13:39:23' , '0000-00-00' , '2020-08-10' , '2020-08-10 12:27:32' , '' , 'x' , '' , '' , '' , 'Y' , '0000-00-00 0 0:00:00' , 'N' , '' , '' , '2' , 0 , '' , '2021-03-13 17:54:58' , '???§?™â€????³?™?†?™â€?' , '' , 'N' , 0 , '0000-00-00 00:00:00' , '' , 'Y' , '' , '' , '' , '' , 'F' ), ( 3392 , 'E' , 1912380 , 0 , 'DAKHLIYA' , 'DAKHLIYA' , 'BAHLA ' , 'LG17CT40591599' , 'A_3PH' , '' , 'Non-Payment' , 'Pole' , '?™â€¦????™â€¦???¯ ???³???¹?™? ???¯' , 0 , '22.99101921' , '57.31331244' , '' , 1791.824 , 'High' , '0000-00-00' , '' , 'YES' , '' , '2020-08-10 13:37:39' , '0000-00-00' , '2020-08-10' , '2020-08-10 12:27:32' , '' , 'x' , '' , '' , '' , 'Y' , '0000-00-00 0 0:00:00' , 'N' , '' , '' , '179' , 0 , '' , '2021-03-13 17:54:58' , '???§?™â€????³?™?†?™â€?' , '' , 'N' , 0 , '0000-00-00 00:00:00' , '' , 'Y' , '' , '' , '' , '' , 'F' ), ( 3960 , 'E' , 1419408 , 0 , 'SOUTH BATI' , 'SOUTH BATI' , 'MUSAN`AH ' , '61669830' , 'A_1PH' , '' , 'Non-Payment' , 'Fuse' , '?™â€¦????™â€¦???¯ ???¨?™â€ ???³?™â€??™? ?™â€¦???§?™â€ ???¨?™â€ ???¹???¨???¯???§?™â€??™â€??™â€? ???§?™â€? ?™â€¦???¬?™? ?™â€ ?™? ' , 95332316 , '23.80120828' , '57.55202312' , '1499' , 2119.465 , 'High' , '0000-00-00' , '' , 'YES' , '' , '2020-08-10 15:20:32' , '0000-00-00' , '2020-08-10' , '2020- 08-10 12:27:32' , '' , 'x' , '' , 'Dc' , '' , 'Y' , '0000-00-00 00:00:00' , 'N' , '' , '' , '' , 0 , '' , '2021-03-13 17:54:58' , '???§?™â€????³?™?†?™â€?' , '' , 'N' , 0 , '0000-00-00 00:00:00' , ' ' , 'Y' , '' , '' , '' , '' , 'F' ), ( 4139 , 'E' , 419008 , 0 , 'SOUTH BATI' , 'SOUTH BATI' , 'RUSTAQ ' , '61489528' , 'A_3PH' , '' , 'Non-Payment' , 'Fuse' , '???³???¹?™? ???¯ ???¨?™â€ ???¹?™â€??™? ???¨?™â€ ???³???¹?™? ???¯ ???§?™â€????³?™â€??™â€¦???§?™â€ ?™? ' , 99009939 , '23.5109084' , '57.4639633' , '407' , 3548.370 , 'High' , '0000-00-00' , '' , 'x' , '' , '2020-08-10 15:25:59' , '0000-00-00' , '2020-08-10' , '2020-08-10 12:27:32' , ' ' , 'x' , '' , '' , '' , 'N' , '0000-00-00 00:00:00' , 'N' , '' , '' , '' , 0 , '' , '2021-03-13 17:54:58' , '???§?™â€????³?™?†?™â€?' , '' , 'N' , 0 , '0000-00-00 00:00:00' , '' , 'Y' , '' , '' , '' , '' , 'F' ), ( 58530 , 'E' , 8028858 , 0 , 'SOUTH BATI' , 'SOUTH BATI' , 'BARKA' , '61637875' , 'A_1PH' , '' , 'Non-Payment' , 'Fuse' , '???³???¹?™? ???¯ ?™?†?™â€¦????™â€¦???¯ ???§???¨?™â€ ?™? ???®?™â€??™???§?™â€ ???¨?™â€ ?™â€¦????™â€¦???¯ ?? ?§?™â€????±???´?™? ???¯?™? ' , 99331120 , '23.676320422425' , '57.843431996236' , '8067' , 309.620 , 'High' , '0000-00-00' , '' , 'YES' , '' , '2020-08-16 16:31:34' , '0000-00-00' , '2020-08-1 6' , '2020-08-16 08:05:52' , '' , 'x' , '' , '' , '' , 'N' , '0000-00-00 00:00:00' , 'N' , '' , '' , '165' , 0 , '' , '2021-03-13 17:54:58' , '???§?™â€????¹?™â€??™? ???±' , '' , 'N' , 0 , '0000-00-00 00:00:00' , '' , 'Y' , '' , '' , '' , '' , 'F' ), ( 111616 , 'E' , 2400454 , 0 , 'SHARQIYAH' , 'SHARQIYAH' , 'AL KAMIL' , '61668588' , 'Fuse' , '' , 'Non-Payment' , 'Fuse' , '????™â€¦???¯ ?™â€¦???¨???§???±?™?’ ????™â€¦???¯ ???§?™â€??™?’?™? ?™â€ ???§?™â€ ?™â€°' , 92411059 , '22.220547109' , '59.201243319' , '322' , 478.940 , 'High' , '0000-00-00' , '' , 'YES' , '' , '2020-08-17 13:44:01' , '0000-00-00' , '2020-08-17' , '2020-08-17 10:46:03' , '' , ' x' , '' , '' , '' , 'N' , '0000-00-00 00:00:00' , 'N' , '' , '' , '229' , 0 , '' , '2021-03-13 17:54:58' , '???§?™â€????¹?™â€??™?†?™? ?™â€? ???§?™â€??™?’???§?™â€¦?™â€?' , '' , 'N' , 0 , '0000-00-00 00:00:00' , '' , 'Y' , '' , '' , '' , '' , 'F' ), ( 111700 , 'E' , 2403303 , 0 , 'SHARQIYAH' , 'SHARQIYAH' , 'AL KAMIL' , '2509711' , 'Fuse' , '' , 'Non-Payment' , 'Pole' , '???®?™â€¦?™? ???³ ???¨?™â€ ???®???§?????™â€¦ ???¨?™â€ ???³?™?†?™? ?™â€??™â€¦ ???§?™â€??™â€¦???¹?™â€¦???±?™â€° ???????¬???§???±?™â€°' , 98249030 , '22.218114546' , '59.201535766' , '383' , 301.920 , 'High' , '0000-00-00' , '' , 'YES' , '' , '2020-08-17 13:09:22' , '0000-00-00' , '2020-08-17' , '2020- 08-17 10:46:03' , '' , '' , '' , 'Fuse' , '' , 'N' , '0000-00-00 00:00:00' , 'N' , '' , '' , '229' , 0 , '' , '2021-03-13 17:54:58' , ' ???§?™â€??™?’???§?™â€¦?™â€?' , '' , 'N' , 0 , '0000-00-00 00:0 0:00' , '' , 'Y' , '' , '' , '' , '' , 'F' ),