07-29-2024, 01:00 PM
crm.myproperty4u.com
650MB SQL/CSV files 01.2024
"21066","Govindpur B.O","845411","B.O","Delivery","East Champaran","Muzaffarpur","Bihar","Areraj","East Champaran","BIHAR","NA","Areraj S.O","Motihari H.O","0","0"
"21067","Gudra B.O","845456","B.O","Delivery","East Champaran","Muzaffarpur","Bihar","Motihari","East Champaran","BIHAR","NA","Sugauli S.O","Motihari H.O","0","0"
"21068","Gulwara Madhuban S.O","845420","S.O","Delivery","East Champaran","Muzaffarpur","Bihar","Madhuban","East Champaran","BIHAR","06259-274230","NA","Motihari H.O","0","0"
INSERT INTO `clients` (`id`, `username`, `cust_type`, `password`, `title`, `name`, `email`, `mobile`, `phone`, `area`, `city`, `address`, `reference`, `status`, `credit_limit`, `officeaddress`, `persontype`, `locationtype`, `howuconnectwithus`, `connectdetails`, `birthdate`, `aniversarydate`, `emailreminders`, `smsreminders`, `firstvisit`, `lastvisit`, `totalvisit`, `remarks`, `officearea`, `gender`, `read`, `floor`, `floor1`, `actcode`, `actstatus`, `clientcode`, `tinno`, `clientcategory`, `pin`, `state`, `captcha`, `gstno`, `openingbalance`) VALUES
(453, 'sainigraphics14@gmail.com', 'SIMPLE', '8769981299', 'Mr.', 'Saini Graphics', 'sainigraphics14@gmail.com', '8769981299', '', '', 'Jaipur', 'Opp. Harmara Police Station, Grand Sikar Road, Jaipur', NULL, 'PENDING', 130, '', '', '', '', '', '0000-00-00', '0000-00-00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', '', '', 1, '1', '1', '', 1, '', '', 'G', '302013', '', 'cacbfcb', '', 0),
(454, 'shankar1234', 'SIMPLE', '1982', 'Mr.', 'krishna and avana company', 'krishnaphoto.lawan@gmail.com', '9784363062', '', '', 'dausa', 'main market lawan dausa', NULL, 'PENDING', 130, '', '', '', '', '', '0000-00-00', '0000-00-00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', '', '', 1, '1', '1', '', 1, '', 'no', 'G', '303004', '', '0437498', '', 0),
(477, 'laxmiemitrarenwal', 'SIMPLE', 'Laxmirenwal123', 'Mr.', 'Laxmi E Mitra (Renwal)', 'laxmiemitrarenwal@gmail.com', '9694727015', '', '', 'JAIPUR', 'Kishangarh Renwal', NULL, 'PENDING', 130, '', '', '', '', '', '0000-00-00', '0000-00-00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', '', '', 1, '1', '1', '', 1, '', '0', 'E', '303603', 'RAJASTHAN', 'a242f40', '', 0),
650MB SQL/CSV files 01.2024
Sample Spoiler
"21066","Govindpur B.O","845411","B.O","Delivery","East Champaran","Muzaffarpur","Bihar","Areraj","East Champaran","BIHAR","NA","Areraj S.O","Motihari H.O","0","0"
"21067","Gudra B.O","845456","B.O","Delivery","East Champaran","Muzaffarpur","Bihar","Motihari","East Champaran","BIHAR","NA","Sugauli S.O","Motihari H.O","0","0"
"21068","Gulwara Madhuban S.O","845420","S.O","Delivery","East Champaran","Muzaffarpur","Bihar","Madhuban","East Champaran","BIHAR","06259-274230","NA","Motihari H.O","0","0"
INSERT INTO `clients` (`id`, `username`, `cust_type`, `password`, `title`, `name`, `email`, `mobile`, `phone`, `area`, `city`, `address`, `reference`, `status`, `credit_limit`, `officeaddress`, `persontype`, `locationtype`, `howuconnectwithus`, `connectdetails`, `birthdate`, `aniversarydate`, `emailreminders`, `smsreminders`, `firstvisit`, `lastvisit`, `totalvisit`, `remarks`, `officearea`, `gender`, `read`, `floor`, `floor1`, `actcode`, `actstatus`, `clientcode`, `tinno`, `clientcategory`, `pin`, `state`, `captcha`, `gstno`, `openingbalance`) VALUES
(453, 'sainigraphics14@gmail.com', 'SIMPLE', '8769981299', 'Mr.', 'Saini Graphics', 'sainigraphics14@gmail.com', '8769981299', '', '', 'Jaipur', 'Opp. Harmara Police Station, Grand Sikar Road, Jaipur', NULL, 'PENDING', 130, '', '', '', '', '', '0000-00-00', '0000-00-00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', '', '', 1, '1', '1', '', 1, '', '', 'G', '302013', '', 'cacbfcb', '', 0),
(454, 'shankar1234', 'SIMPLE', '1982', 'Mr.', 'krishna and avana company', 'krishnaphoto.lawan@gmail.com', '9784363062', '', '', 'dausa', 'main market lawan dausa', NULL, 'PENDING', 130, '', '', '', '', '', '0000-00-00', '0000-00-00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', '', '', 1, '1', '1', '', 1, '', 'no', 'G', '303004', '', '0437498', '', 0),
(477, 'laxmiemitrarenwal', 'SIMPLE', 'Laxmirenwal123', 'Mr.', 'Laxmi E Mitra (Renwal)', 'laxmiemitrarenwal@gmail.com', '9694727015', '', '', 'JAIPUR', 'Kishangarh Renwal', NULL, 'PENDING', 130, '', '', '', '', '', '0000-00-00', '0000-00-00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '', '', '', 1, '1', '1', '', 1, '', '0', 'E', '303603', 'RAJASTHAN', 'a242f40', '', 0),
Reply
Reply
Reply
![[Image: l0xgkt9q.gif]](https://external-content.duckduckgo.com/iu/?u=https%3A%2F%2Fexternal-content.duckduckgo.com%2Fiu%2F%3Fu%3Dhttp%3A%2F%2Fpomf2.lain.la%2Ff%2Fl0xgkt9q.gif)