I have a scenario where I have to form sql queries in a file using echo command.
I have file1 which has more than 10 lac numbers. For each Number in file 1, I need to create 5 sql queries resulting in 50 lac queries totally.
For doing this I use the below simple method,
Code:
for i in `cat file1 | tr -d '\r'`
do
echo "update table set id1=0 where no='$i';" >>query.unl
echo "update table set id2=0 where no='$i';" >>query.unl
echo "update table set id3=0 where no='$i';" >>query.unl
echo "update table set id4=0 where no='$i';" >>query.unl
echo "update table set id5=0 where no='$i';" >>query.unl
done
It takes me more than 12 hours to form the query.unl. Any other efficient and simple way to do this without modifying the file 1 (source file) ???
Dear All
I am facing below mention problem plz suggest me solution.
Op of date command:
> date
Tue Jan 1 12:17:52 IST 2008
Now i want Jan 1 12: or Jan 1 12 op in some another variable.
I had tried awk but if give me problem when there is date comes in 2 digit i.e. greater that 9.... (1 Reply)
Hi,
I am trying to extract all .sql files present in a particular directory and its sub directories. How can i do this using shell script or awk?
any help would be earnestly appreciated.
thanks. (1 Reply)
Hi I am going to migrate our datawarehouse system from HP Tru 64 Unix to the Red Hat Linux.
Inside the box, it is running around 40 cron jobs; inside each cron job, it is calling other shell script files, and the shell script files may again call other shell script files or ctl files(for... (1 Reply)
Hello all,
I have a shell script that uses multiple .sql files. These .sql files mainly contain Oracle SQL queries to pull fields from the database. I want to place all the contents of these .sql files in one .sql file and have some parameter sent based on which the respective block or query... (6 Replies)
I have a data like as follows, I need to format it as shown in as below. Request you to help me here ?
I/P
aa|3|1
aa|4|2
bb|3|1
bb|4|1
cc|3|26
cc|4|1
O/P
aa|3|1|4|2
bb|3|1|4|1
cc|3|26|4|1
Thanks,
Srikanth (5 Replies)
I tried executing set of queries from shell script but not able to capture the input query in the log file,but the input query is not displayed along with output. Only the outputs are being captured in the log file. Is there a way to capture the input query along with the corresponding input?? (8 Replies)
I need help to create varieties of football formation. The available positions are:
GK
SW
DR
DC
DL
WBR
DM
WBL
MR
MC
ML
AMR
AMC
AML
ST
But the conditions are:
a. the maximum number in 1 formation:
GK is 1
SW is 1 (1 Reply)
I'm trying to create a perl script that will automatically fit the player's name to the formation.
For example, in my:
DR.txt
Arbeloa 200
Carvajal 190
Ramos 180
DC.txt
Ramos 200
Pepe 190
Varane 180
DL.txt
Marcelo 200
Coentrao 190
Arbeloa 180
formation.txt:
DR
DC
DC
DL
DR (7 Replies)
https://www.unix.com/programming/252468-perl-script-create-football-formation.html https://www.unix.com/members/43551.html, it is not repeated question. please read it before u block my question. Unblock it for me. Thanks:mad: (0 Replies)
Discussion started by: Tzeronone
0 Replies
LEARN ABOUT DEBIAN
cvm-mysql
cvm-mysql(8) System Manager's Manual cvm-mysql(8)NAME
cvm-mysql - MySQL module
SYNOPSIS
cvm-mysql
CREDENTIALS
Pass phrase
DESCRIPTION
This module queries a MySQL database for the account name, compares the stored pass phrase with the given one using crypt(3).
CONFIGURATION VARIABLES
CVM_MYSQL_DEFAULT_FILE
The full path of the defaults file to read if the following variable is set. If not set, the file $HOME/.my.cnf will be read (the
MySQL default).
CVM_MYSQL_DEFAULT_GROUP
If set, the module will read connection default options from the named group in the defaults file as above
CVM_MYSQL_HOST
The hostname or IP of the MySQL server. If not set, a connection to the local host is assumed.
CVM_MYSQL_USER
The MySQL login ID to connect as. If not set, the invoking user is assumed.
CVM_MYSQL_PASS
The password for the above user.
CVM_MYSQL_DB
The database name, must be set.
CVM_MYSQL_PORT
The port number for the TCP/IP connection (only used if the server is not local).
CVM_MYSQL_POSTQ (optional)
The SQL query to execute after the credentials have been validated, see cvm-sql(7).
CVM_MYSQL_PWCMP (optional)
The password comparison module to use.
CVM_MYSQL_SOCKET
The path to the socket that should be used for connections to a local server.
CVM_MYSQL_QUERY (optional)
The SQL query to issue to retrieve the row containing the account information from the database, see cvm-sql(7).
SEE ALSO cvm-sql(7), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8), cvm-test-
client(8)
http://untroubled.org/pwcmp/pwcmp.html
http://untroubled.org/cvm/cvm.html
cvm-mysql(8)