For loop mysql procedures Post: 302981405

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Procedures are not called ?

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. UNIX for Dummies Questions & Answers

Stored Procedures

Dear friends, can anyone suggest links for online books on stored procedures in oracle. Cheers,

3. Shell Programming and Scripting

Needed help in understanding these procedures?

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...

4. Shell Programming and Scripting

calling two procedures from one ksh ???

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. Debian

Procedures in the #apt commands.

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...

6. Programming

Loop in bash file for mysql

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...

LEARN ABOUT OPENSOLARIS

mysql_zap

zap(1)								  MySQL database							    zap(1)

NAME

       zap - a perl script used to kill processes

USAGE

       /usr/bin/mysql_zap [-signal] [-?Ift] pattern

SYNOPSIS

       zap [-I|-?]  [-f] [-t]

DESCRIPTION

       zap    supports by executing

       -I|-?  info

       -f     force

       -t     test

NOTE

       If  -f isn't given, ask user for confirmation for each process to kill. If signal isn't given, try first with signal 15 and after that with
       signal 9. If -t is given the processes is only shown on stdout.

SEE ALSO

       isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi-
       lege_tables(1), mysqlshow(1), perror(1), replace(1)

       For  more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online
       at http://www.mysql.com/doc/en/

BUGS

       Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR

       Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no war-
       ranty.  Manual  page  by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercurme-
       dia.com)

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +--------------------+------------------------------------+
       |  ATTRIBUTE TYPE    |	       ATTRIBUTE VALUE		 |
       +--------------------+------------------------------------+
       |Availability	    | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
       +--------------------+------------------------------------+
       |Interface Stability | External				 |
       +--------------------+------------------------------------+
NOTES

       Source for mysql is available on http://opensolaris.org.

MySQL 4.0							 19 December 2000							    zap(1)