Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 534
  • Last Modified:

resolving an error inserting multiple records into one database.table from a multitable select accross databases

i need to insert into table test via mysql in a php document, a built select from various tables in the table production. below is the output - the first element of the array is the sql query, and the second element is the sql error returned.
Array
(
    [0] => 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;

    [1] => 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

)

Open in new window

what does this mean in this instance, and how do i resolve it ASAP?
0
intellisource
Asked:
intellisource
1 Solution
 
intellisourceAuthor Commented:
nevermind - INSERT statements can only insert into one table at a time, thus no aliases are allowed. ;) removed the aliases and the sql query runs successfully! XD
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now