in reply to Re^4: split a line into 2 variables and store in SQL
in thread split a line into 2 variables and store in SQL
browsing SQL should start you off.UPDATE table SET foo = bar WHERE condition
BTW, you do realise that the split you perform won't work with word1 := word2; since the value you split on doesn't exist, try /\s*.=\s/* as the regex - in that way, you'll remove white space either side of the tokens you actually want.
Alternatively, just use vanilla split and use the 1st and 3rd elements of the resulting array e.g.
while (<>) { my @args = split; # Now use $args[0] & $args[2] as appropriate . . }
|
|---|