09-12-2016
Hello
yahyaaa ,
I have a few to questions pose in response first:-
- What have you tried so far?
- What output/errors do you get?
- What OS and version are you using?
- Does this need to be with a single mysql call, or would you be okay to loop in the shell calling mysql multiple times?
- What logical process have you considered? (to help steer us to follow what you are trying to achieve)
Most importantly,
What have you tried so far?
There are probably many ways to achieve most tasks, so giving us an idea of your style and thoughts will help us guide you to an answer most suitable to you so you can adjust it to suit your needs in future.
We're all here to learn and getting the relevant information will help us all.
Robin
6 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
My shell script is executing i am having no syntax errors or other errors. When i am testing the shell script i am having a problem that the procedure Prompt, Environment,List are not found.
I defined all these procedures in the shell script.
Environment()
{
FULL=N export FULL
LOGON=cat... (2 Replies)
Discussion started by: dreams5617
2 Replies
2. UNIX for Dummies Questions & Answers
Dear friends,
can anyone suggest links for online books on stored procedures in oracle.
Cheers, (2 Replies)
Discussion started by: thumsup9
2 Replies
3. Shell Programming and Scripting
Hi all,
i needed some help in understanding a few procedures and how exactly is the sequence?
FINISHED="Done"
COLUMNS=$( stty -a | head -n 2 | cut -d " " -f2 |cut -d " " -f4 )
COLS=$((${COLUMNS} -${#FINISHED} - 5))
RET_ARR="\010"
KILLLINE=${RET_ARR}${RET_ARR}
for i in $(seq 1... (0 Replies)
Discussion started by: wrapster
0 Replies
4. Shell Programming and Scripting
Hi to all,
This is first posting in this forum. I quite new to this KSH....i guess i ll have some fun...:)
Well, I have two indivdual korn shell scripts. i m calling PL/SQL stored procedure from korn shell script. It works absolutely fine. Once its completed the log is updated and data is... (5 Replies)
Discussion started by: shashi369
5 Replies
5. Debian
I have installed squeeze 6.0.0 as a base install from: Network install from a minimal CD.
Debian -- Network install from a minimal CD
i do see a lot of information on the various #apt commands , yet is is all garble goop as far as trying to make sense of where to begin at to install... (3 Replies)
Discussion started by: cowLips
3 Replies
6. Programming
Hi,
I'm having problems with a script which some of you helped me with last week. It's a script to check the status of orders in an SQL database, and if the count(*) is zero, then the script stops. If it's non-zero, the script echos the result to a file and then in cron, I cat the file and mail... (3 Replies)
Discussion started by: davidm123SED
3 Replies
LEARN ABOUT REDHAT
foreach
foreach(n) Tcl Built-In Commands foreach(n)
__________________________________________________________________________________________________________________________________________________
NAME
foreach - Iterate over all elements in one or more lists
SYNOPSIS
foreach varname list body
foreach varlist1 list1 ?varlist2 list2 ...? body
_________________________________________________________________
DESCRIPTION
The foreach command implements a loop where the loop variable(s) take on values from one or more lists. In the simplest case there is one
loop variable, varname, and one list, list, that is a list of values to assign to varname. The body argument is a Tcl script. For each
element of list (in order from first to last), foreach assigns the contents of the element to varname as if the lindex command had been
used to extract the element, then calls the Tcl interpreter to execute body.
In the general case there can be more than one value list (e.g., list1 and list2), and each value list can be associated with a list of
loop variables (e.g., varlist1 and varlist2). During each iteration of the loop the variables of each varlist are assigned consecutive
values from the corresponding list. Values in each list are used in order from first to last, and each value is used exactly once. The
total number of loop iterations is large enough to use up all the values from all the value lists. If a value list does not contain enough
elements for each of its loop variables in each iteration, empty values are used for the missing elements.
The break and continue statements may be invoked inside body, with the same effect as in the for command. Foreach returns an empty string.
EXAMPLES
The following loop uses i and j as loop variables to iterate over pairs of elements of a single list. set x {} foreach {i j} {a b c d e f}
{
lappend x $j $i } # The value of x is "b a d c f e" # There are 3 iterations of the loop.
The next loop uses i and j to iterate over two lists in parallel. set x {} foreach i {a b c} j {d e f g} {
lappend x $i $j } # The value of x is "a d b e c f {} g" # There are 4 iterations of the loop.
The two forms are combined in the following example. set x {} foreach i {a b c} {j k} {d e f g} {
lappend x $i $j $k } # The value of x is "a d e b f g c {} {}" # There are 3 iterations of the loop.
SEE ALSO
for(n), while(n), break(n), continue(n)
KEYWORDS
foreach, iteration, list, looping
Tcl foreach(n)