In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
what does this mean in this instance, and how do i resolve it ASAP?
Array (  => INSERT INTO dwtphovu_8347379386_test.6_serviceleads TSL ( TSL.bigint_LeadID, TSL.text_Consumer, TSL.text_LeadAttributes, TSL.timestamp_ExpectedBy, TSL.text_LeadMessage, TSL.bigint_ServiceID, TSL.bigint_SupplierID, TSL.bigint_RegionID, TSL.tinyint_LeadSent, TSL.timestamp_LeadCreated, TSL.text_Duplicates ) SELECT bigint_LeadID, text_Consumer, text_LeadAttributes, timestamp_ExpectedBy, text_LeadMessage, bigint_ServiceID, bigint_SupplierID, ( SELECT TR.bigint_RegionID FROM dwtphovu_8347379386_test.1_regions TR, dwtphovu_8347379386_prod.1_regions PR WHERE CONCAT("%",UPPER(PR.text_RegionDescription),"%") LIKE CONCAT("%",UPPER(TR.text_RegionDescription),"%") AND PR.bigint_RegionID = PSL.bigint_RegionID ) AS bigint_RegionID, tinyint_LeadSent, timestamp_LeadCreated, text_LeadSubject FROM dwtphovu_8347379386_prod.6_serviceleads PSL;  => ERROR #1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TSL ( TSL.bigint_LeadID, TSL.text_Consumer, TSL.text_LeadAttribu' at line 2 in /home/dwtphovu/public_html/intellisource.co.za/test_8347379386/db_synchronizer.php on Line 57 )
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.