That's, this looks good!
I just had some other feedback on a possible workaround to the second import.
Right before doing the migration, create a query that would add a "paymentinfoid" to the original table. This way the second import can simply be treated as 2 separate imports.
Unfortunately, I was not give any examples of how the actual queries would look.
How would I create an additional colum that would AUTO_INCREMENT from a number I specify (After i check for last number in "To_paymentinfo" table)?
Also, do do this:
subscriptionsubid ------------ < --- ("2" IF above field mc_gross is 4, "1" IF above field mc_gross is 6, "0" IF above field mc_gross is 10)
I would probably end up running 3 different queries based on the number in the mc_gross field. Would I be able to create a query that says "Only run IF that field value is x?
|