MySQL Forums
Forum List  »  Newbie

code
Posted by: mysql Wonder
Date: January 30, 2014 05:20PM

Hi,

I am new of mysql, and i have to insert 72 rows to table, inner join with other table. But in return, there are 2 numbers. Does some one know what's the first number and where it comes from?
Thanks

------------------------

Begin Tran

INSERT INTO [EnterpriseDb] ..table1
( column1,.......column7)
SELECT '710',c.[AGE],c.[MAX],'N',c.[CODE_ID],'0' ,'1','999' ,'1' ,'2014-01-01',NULL,t2.[U3],GETDATE()
FROM [UserDb]..table2 AS t2
INNER JOIN [EnterpriseDb] ..table3 AS t3 ON CAST([t2].
 AS VARCHAR(5)) = [t3].
		
-- 72 rows
----------------------------------------------
Return as:
864 rows affected

72 rows affected

Options: ReplyQuote


Subject
Written By
Posted
code
January 30, 2014 05:20PM
January 30, 2014 07:07PM
January 31, 2014 08:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.