12-29-2004
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I am having trouble through, I am reading the input from tab delimited file containing several records,
e.g.
line1 field1 field2 field3 so on..
line2 field1 field2 field3 so on..
..
..
on the basis of certain fields for each record in input file, I have to retrieve... (1 Reply)
Discussion started by: Sonu4lov
1 Replies
2. Shell Programming and Scripting
hello everyone
I need to update data base in file
1-ID
2-Name
3-ID group
4-ID teacher
5-mark list
unique ID is (ID+ID group+ID teacher)
we can append 5 th columns (marks list)
main base file:
Code:
1:John:3:1:4 3 2
2:Mark:1:2:1 3
3:Susan:3:4:
input file: (1 Reply)
Discussion started by: mleplawy
1 Replies
3. Shell Programming and Scripting
Is this a permission issue I got this shl that runs okay in one data base but not in another DB in UNIX
i changed the real names for xxx for this post
!/bin/ksh
set -x
##SID="$1";
##SIDQ="@${SID}";
##ORACLE_SID="@${SID}";
# set database name
SID=$ORACLE_SID;
LOWER_SID=`echo... (1 Reply)
Discussion started by: rechever
1 Replies
4. Shell Programming and Scripting
HI
I have input file A.txt
X
Y
Z
File B.txt
1 X 10 AAA 11123
2 Y 22 PlD 4563
3 Z 55 PlD 54645
4 Z 66 PlD 15698
5 F 44 PlD 154798
6 C 55 PlD 12554
7 Z 88 PlD 23265
8 C 99 PlD 151654
9 C 11 PlD 21546546
I need New File C.txt (1 Reply)
Discussion started by: pareshkp
1 Replies
5. Shell Programming and Scripting
Hi All,
I have the file in following format. I need to change column 16 and column 17 for those lines which has atleast one numerical digit in column 2 , with the exception on SUPP1
Input file :
S00005615|1044|0|0.00|0|0.00| |112|-30|28.1|0|0| |20130331|220.2|2|3|... (2 Replies)
Discussion started by: nua7
2 Replies
6. Shell Programming and Scripting
Base of last two column i want to change may data
if Last two Column have A and C then Copy Column $4 to Column $3.
Input :-
DD142 0_1 DD142_A DD142_B A B
DD142 1_1 DD142_B DD142_C B C
DD142 2_1 DD142_A DD142_C A C
DD142 3_1 DD142_A A
DD142 3_2 DD142_A A
DD142 4_1 DD142_B B ... (4 Replies)
Discussion started by: pareshkp
4 Replies
7. Shell Programming and Scripting
File 1
ID Name Po1 Po2
DD134 DD134_4A_1 NN-1 L_0_1
DD134 DD134_4B_1 NN-2 L_1_1
DD134 DD134_4C_1 NN-3 L_2_1
DD142 DD142_4A_1 NN-1 L_0_1
DD142 DD142_4B_1 NN-2 L_1_1
DD142 DD142_4C_1 NN-3 L_2_1
DD142 DD142_3A_1 NN-41 L_3_1
DD142 DD142_3A_1 NN-42 L_3_2
File 2 ( Combination of... (1 Reply)
Discussion started by: pareshkp
1 Replies
8. Shell Programming and Scripting
HI
Want to grep data from column header and match with second file.
File A.txt
1 2 3 4 5 6
X1 A L D J Q R
X2 B M K P w T
X3 C S L P e Y
X4 R Z M A r U
FileB.txt
1
2
3
4
6
7 (3 Replies)
Discussion started by: pareshkp
3 Replies
9. Shell Programming and Scripting
HI Guys,
File A.txt
UID,HD1,HD2,HD3,HD4
1,2,33,44,55
2,10,14,15,16
File B.txt
UID
HD1
HD4
A.txt B.txt >>>Output.txt
UID,HD1,HD4
1,2,55
2,10,16 (11 Replies)
Discussion started by: pareshkp
11 Replies
MYSQL(1) General Commands Manual MYSQL(1)
NAME
mysql - text-based client for mysqld, a SQL-based relational database daemon
SYNOPSIS
mysql [-B|--batch] [-#|--debug= logfile] [-T|--debug-info] [-e|--exec= command] [-f|--force] [-?|--help] [-h|--host= hostname]
[-n|--unbuffered] [-p[pwd]] [--password=[pwd]] [-P|--port= pnum] [-q|--quick] [-r|--raw] [-s|--silent] [-S|--socket= snum] [-u|--user=
uname] [-v|--verbose] [-V|--version] [-w|--wait]
DESCRIPTION
The mysql program provides a curses-based interface to the SQL-based database server daemon, mysqld(1). Full fuller documentation, refer
to the HTML documents installed with the package.
OPTIONS
-B|--batch
Print results with a tab as separator, each row on a new line.
-#|--debug=logfile
Employ the specified debug log.
-T|--debug-info
Print debug information upon exiting.
-e | --exec=command
Execute the specified command and quit (--batch is implicit).
-f|--force
Continue even if the face of a SQL error.
-?|--help
Display a help message and exit.
-h|--host=hostname
Connect to the specified host.
-n|--unbuffered
Flush the buffer after each query.
-p|--password[=pwd]
Employ the specified password when connecting to the database server. If a password is not supplied, it will be requested interac-
tively.
-P|--port=pnum
Employ the specified port number for connecting to the database server.
-q|--quick
Do not cache the result; print it row by row. This may slow down the server if the output is suspended.
-r|--raw
Write fields without conversion. (used with --batch).
-s|--silent
Silent mode: reduce the amount of output.
-S|--socket=snum
Employ the specified socket file for connecting to the database server.
-u|--user=uname
Employ the specified user name for logging in to the server.
-v|--verbose
Verbose mode: write more Specifying this option twice produces a tabular output format.
-V|--version
Print the mysql version number and exit.
-w|--wait
Wait and retry if the database server connection is down.
FILES
/depot/bin/mysql executable
/depot/bin/mysqld executable
/depot/bin/safe_mysqld
executable shell script for starting mysqld safely
/site/var/mysql/data location of database files
EXAMPLE
You can also read a backup dump file back into MySQL with:
mysql database < backup-file.sql
SEE ALSO
isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror
(1), replace (1), safe_mysqld (1), which1 (1), zap (1),
AUTHOR
Ver 6.3, distribution 3.20.20 Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se). This software comes with no
warranty. Manual page by R. P. C. Rodgers, Lister Hill National Center for Biomedical Communication, U.S. National Library of Medicine
(rodgers@nlm.nih.gov).
13 June 1997 MYSQL(1)