Click here to Skip to main content
12,398,537 members (58,278 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: MySQL
hi to all,
I have a table in mysql in which there are 8 columns among that I want to insert 5 values from another table using select statement and remaining 3 want to insert using parameters sent from the code behind. How it is possible? Please help me...Thanks in advance...
Posted 15-Jan-13 19:30pm

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Check this example

BEGIN
DECLARE @FINE VARCHAR(20)
DECLARE @DAYS_LATE INT
SET @FINE=12
SET @DAYS_LATE=2
INSERT INTO FINE(ACCNO,PATNUM,FINE,DAYS_LATE)
SELECT ACCNO,PATNUM,(SELECT @FINE),(SELECT @DAYS_LATE) FROM HIRE
 
END
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 16 Jan 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100