09-27-2005
use if......
if((a==1)||(a==2)||(a==3))
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi,
i am try to run following script in c-shell, using switch command.
#!/bin/csh
choice=0
while
do
echo "system monitor"
echo "
1) system paging
2) system file inf.
3) system disk inf.
9) exit
"
echo "select an option: \c"
read choice
case $choice in
1)... (3 Replies)
Discussion started by: neer45
3 Replies
2. Shell Programming and Scripting
Hi, have managed to code a script that has a simple menu so for instance if I run:
this will call a help function that displays the programs help, I have coded this in using a case statement so if: case is h) call the help function
The problem is I don't know how to code in the... (3 Replies)
Discussion started by: Del33t
3 Replies
3. UNIX for Advanced & Expert Users
Hi,
How can I switch from one login to another login in UNIX. su command is disabled in my environment. Is there any alternate way to login. (1 Reply)
Discussion started by: sharif
1 Replies
4. Shell Programming and Scripting
Hi,
This script receive in input 2 parameters, the use $2 in this way:
switch ($2)
case r:
p=r--
echo $2 ok
breaksw
case rw:
p=rw-
echo $2 ok
breaksw
case rwx:
p=rwx
echo $2 ok
breaksw
default... (5 Replies)
Discussion started by: DNAx86
5 Replies
5. UNIX for Advanced & Expert Users
Hello Community!
Anyone knows how can I access the switch for monitoring the traffic on my LAN?
The switch is a Linksys sr2024
Thanks in advance (1 Reply)
Discussion started by: ncatdesigner
1 Replies
6. Shell Programming and Scripting
Guys,
I need to copy files from source to destination with datetime preserved
I did it with cp -p <source>/file <destinaltion>/file
But when I do stat command on copied file , it seems the copied file has "change time" modified.
Please guide me in understanding (2 Replies)
Discussion started by: mohan_xunil
2 Replies
7. Shell Programming and Scripting
hi,
how to access console of a switch having rj45 on switch side to db 9 female on pc side console cable which needs to be connected to one console server having rj11 on its side and db 9 female on other end.i.e. on switch side,console cable has rj45 and db 9 pin female connector on other side of... (1 Reply)
Discussion started by: pankajd
1 Replies
8. UNIX for Dummies Questions & Answers
Howdy, I'm trying to tar a bunch of files into their own individual tar archives. In other words i have files a.txt thru z.txt and i want to create a.tar thru z.tar in the same folder. I've been using -T to read in the list of files to be archived but i can't get it to work. I think my problem is... (5 Replies)
Discussion started by: fistikuffs
5 Replies
9. Solaris
Hi,
I've put the correct root password but why do I get this below?
huamin@SOL11I:~$ su
Password:
su: Sorry
huamin@SOL11I:~$
Many Thanks & Best Regards,
HuaMin (16 Replies)
Discussion started by: HuaMin
16 Replies
LEARN ABOUT PHP
mysqlnd_ms_query_is_select
MYSQLND_MS_QUERY_IS_SELECT(3) 1 MYSQLND_MS_QUERY_IS_SELECT(3)
mysqlnd_ms_query_is_select - Find whether to send the query to the master, the slave or the last used MySQL server
SYNOPSIS
int mysqlnd_ms_query_is_select (string $query)
DESCRIPTION
Finds whether to send the query to the master, the slave or the last used MySQL server.
The plugins built-in read/write split mechanism will be used to analyze the query string to make a recommendation where to send the query.
The built-in read/write split mechanism is very basic and simple. The plugin will recommend sending all queries to the MySQL replication
master server but those which begin with SELECT, or begin with a SQL hint which enforces sending the query to a slave server. Due to the
basic but fast algorithm the plugin may propose to run some read-only statements such as SHOW TABLES on the replication master.
PARAMETERS
o $query
- Query string to test.
RETURN VALUES
A return value of MYSQLND_MS_QUERY_USE_MASTER indicates that the query should be send to the MySQL replication master server. The function
returns a value of MYSQLND_MS_QUERY_USE_SLAVE if the query can be run on a slave because it is considered read-only. A value of
MYSQLND_MS_QUERY_USE_LAST_USED is returned to recommend running the query on the last used server. This can either be a MySQL replication
master server or a MySQL replication slave server.
If read write splitting has been disabled by setting mysqlnd_ms.disable_rw_split, the function will always return
MYSQLND_MS_QUERY_USE_MASTER or MYSQLND_MS_QUERY_USE_LAST_USED.
EXAMPLES
Example #1
mysqlnd_ms_query_is_select(3) example
<?php
function is_select($query)
{
switch (mysqlnd_ms_query_is_select($query))
{
case MYSQLND_MS_QUERY_USE_MASTER:
printf("'%s' should be run on the master.
", $query);
break;
case MYSQLND_MS_QUERY_USE_SLAVE:
printf("'%s' should be run on a slave.
", $query);
break;
case MYSQLND_MS_QUERY_USE_LAST_USED:
printf("'%s' should be run on the server that has run the previous query
", $query);
break;
default:
printf("No suggestion where to run the '%s', fallback to master recommended
", $query);
break;
}
}
is_select("INSERT INTO test(id) VALUES (1)");
is_select("SELECT 1 FROM DUAL");
is_select("/*" . MYSQLND_MS_LAST_USED_SWITCH . "*/SELECT 2 FROM DUAL");
?>
The above example will output:
INSERT INTO test(id) VALUES (1) should be run on the master.
SELECT 1 FROM DUAL should be run on a slave.
/*ms=last_used*/SELECT 2 FROM DUAL should be run on the server that has run the previous query
SEE ALSO
Predefined Constants, user filter .Runtime configuration, mysqlnd_ms.disable_rw_split, mysqlnd_ms.enable.
PHP Documentation Group MYSQLND_MS_QUERY_IS_SELECT(3)