Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 insert into from a list of data

Author  Topic 

singhto
Starting Member

1 Post

Posted - 2012-11-15 : 21:07:34
Hi all, Could you tell me please how to insert a list of data from a variable to database mysql. i have data like this
$minute= 10 20 40 50 ..
and table hour has column as 1h 2h 3h 4h ..
so how i insert $minute to the hour by match with there column

thanks all..



singh

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-11-15 : 22:07:32
are the values stored in same variable? if yes you should be using string parsing function like below to separate values out and then use it for matching

http://visakhm.blogspot.in/2010/02/parsing-delimited-string.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -