Saturday

Limit 20000 per table


>>> Update tbl_register_rwd

SELECT MAX(`RecNo`) AS MaxRec FROM `tbl_register_rwd`
MaxRec:45745
SELECT `RecNo`, `DateCalc`, `RewardID`, `WalletNameReceiver`, `FUllNameReceiver`, `RewardAmount`, `WalletNameRegistered`, `FullNameRegistered`, `GenNo` FROM `view_register_rwd` WHERE ( `RecNo`>'45745' ) ORDER BY `RecNo` Limit 20000
>>> Update tbl_sde_rwd

SELECT MAX(`RecNo`) AS MaxRec FROM `tbl_sde_rwd`
MaxRec:87961
SELECT `RecNo`, `DateCalc`, `RewardID`, `WalletNameReceiver`, `FUllNameReceiver`, `RewardAmount`, `WalletNameRegistered`, `FullNameRegistered`, `GenNo` FROM `view_sde_rwd` WHERE ( `RecNo`>'87961' ) ORDER BY `RecNo` Limit 20000
>>> Update tbl_activate_rwd

SELECT MAX(`RecNo`) AS MaxRec FROM `tbl_activate_rwd`
MaxRec:89924
SELECT `RecNo`, `DateCalc`, `RewardID`, `WalletNameReceiver`, `FUllNameReceiver`, `RewardAmount`, `WalletNameRegistered`, `FullNameRegistered`, `GenNo` FROM `view_activate_rwd` WHERE ( `RecNo`>'89924' ) ORDER BY `RecNo` Limit 20000
>>> Update tbl_subcription_rwd

SELECT MAX(`RecNo`) AS MaxRec FROM `tbl_subcription_rwd`
MaxRec:1310243
SELECT `RecNo`, `DateCalc`, `RewardID`, `WalletNameReceiver`, `FUllNameReceiver`, `RewardAmount`, `WalletNameRegistered`, `FullNameRegistered`, `GenNo` FROM `view_subcription_rwd` WHERE ( `RecNo`>'1310243' ) ORDER BY `RecNo` Limit 20000
1 ) INSERT INTO `tbl_subcription_rwd`(`RecNo`, `DateCalc`, `RewardID`, `WalletNameReceiver`, `FUllNameReceiver`, `RewardAmount`, `WalletNameRegistered`, `FullNameRegistered`, `GenNo`, `RefDate`, `RefMonth`, `RefYear`) VALUES ('1310244','2022-07-03 05:02:13','RWDPSR16567957347760MID1014012','MAZ2589','MAZLINA BINTIABDMUTHALIFF','0.768', 'MAZ2589','MAZLINA BINTIABDMUTHALIFF','0',date_format('2022-07-03 05:02:13','%Y-%m-%d'),date_format('2022-07-03 05:02:13','%Y-%m'),date_format('2022-07-03 05:02:13','%Y'))
2 ) INSERT INTO `tbl_subcription_rwd`(`RecNo`, `DateCalc`, `RewardID`, `WalletNameReceiver`, `FUllNameReceiver`, `RewardAmount`, `WalletNameRegistered`, `FullNameRegistered`, `GenNo`, `RefDate`, `RefMonth`, `RefYear`) VALUES ('1310245','2022-07-03 05:02:13','RWDPSR16567957347861MID1009617','YUS0515','YUSOFF BIN MAT','0.384', 'MAZ2589','MAZLINA BINTIABDMUTHALIFF','1',date_format('2022-07-03 05:02:13','%Y-%m-%d'),date_format('2022-07-03 05:02:13','%Y-%m'),date_format('2022-07-03 05:02:13','%Y'))
3 ) INSERT INTO `tbl_subcription_rwd`(`RecNo`, `DateCalc`, `RewardID`, `WalletNameReceiver`, `FUllNameReceiver`, `RewardAmount`, `WalletNameRegistered`, `FullNameRegistered`, `GenNo`, `RefDate`, `RefMonth`, `RefYear`) VALUES ('1310246','2022-07-03 05:02:13','RWDPSR16567957347972MID1000418','NORA7710','NORAZAH BINTI ISMAIL','0.3071', 'MAZ2589','MAZLINA BINTIABDMUTHALIFF','2',date_format('2022-07-03 05:02:13','%Y-%m-%d'),date_format('2022-07-03 05:02:13','%Y-%m'),date_format('2022-07-03 05:02:13','%Y'))
......
>>> Update tbl_vas_rwd

SELECT MAX(`RecNo`) AS MaxRec FROM `tbl_vas_rwd`
MaxRec:3100819
SELECT COUNT(`RecNo`) AS NUM FROM `view_vas_rwd` WHERE ( `RecNo`>'3100819' )
SELECT `RecNo`, `DateCalc`, `RewardID`, `WalletNameReceiver`, `FUllNameReceiver`, `RewardAmount`, `WalletNameRegistered`, `FullNameRegistered`, `GenNo` FROM `view_vas_rwd` WHERE ( `RecNo`>'3100819' ) ORDER BY `RecNo` Limit 20000
>>> Update tbl_group_rwd

SELECT MAX(`RecNo`) AS MaxRec FROM `tbl_group_rwd`
MaxRec:11812
SELECT `RecNo`, `DateCalc`, `RewardID`, `WalletNameReceiver`, `FUllNameReceiver`, `TotalPairing1`, `TotalPairing2`, `AmountPair1`, `AmountPair2`, `RewardAmount` FROM `view_group_rwd` WHERE ( `RecNo`>'11812' ) ORDER BY `RecNo` Limit 20000
>>> Update tbl_member_info

SELECT MAX(`MemberNo`) AS MaxRec FROM `tbl_member_info`
MaxRec:1027199
SELECT `MemberNo`, `MemberUsername`, `MDUsername`, `FullName`, `NRIC`, `TelMobile`, `IntroducerNo`, `IntroducerUsername`, `PlacementNo`, `PlacementUsername`, `DEIntroducerNo`, `DEIntroducerUsername`, `KeyinByNo`, `KeyinByUsername`, `Position`, `StatusReg`, `DateReg`, `DateActivate`, `NumOfSponsoring`, `NumInSponsorship`, `IntroducerList`, `StatusPlanSubcription`, `PlanSubcriptionExpire`, `Expire`, `DateLastUpdate` FROM `tbl_member_info` WHERE ( `MemberNo`>'1027199' ) ORDER BY `MemberNo` Limit 20000
1 ) INSERT INTO `tbl_member_info` (`MemberNo`, `MemberUsername`, `MDUsername`, `FullName`, `NRIC`, `TelMobile`, `IntroducerNo`, `IntroducerUsername`, `PlacementNo`, `PlacementUsername`, `DEIntroducerNo`, `DEIntroducerUsername`, `KeyinByNo`, `KeyinByUsername`, `Position`, `StatusReg`, `DateReg`, `DateActivate`, `NumOfSponsoring`, `NumInSponsorship`, `IntroducerList`, `StatusPlanSubcription`, `PlanSubcriptionExpire`, `DateLastUpdate` ) VALUES ('1027200','STAR_PA','STAR_PA','STAR PA','000000000000', '', '','','0','', '0', '', '0','','0', '1', '2022-01-28 00:00:00', '1000-01-01','0','0', '', '1', '','1000-01-01')Incorrect integer value: '' for column 'IntroducerNo' at row 1