I always kind of wondered this but I have a variable that I want to use in a search and replace. Basically I want to search a file for the string in my variable and replace it with something fixed but I'm unsure of the variable rule in sed. Here's generally what I have:
sed 's/$name/newname/g'... (15 Replies)
Hi all,
I have debugged this code and i am getting the syntax error at : `<<' unmatched.Please give solution trip
while($i<= 10)
do
sqlplus -s $DBUSER/$DBPWD@$DBHOST << EOF > oraerror.log
whenever sqlerror exit
exit
EOF
i=`expr ${i} + 1`
egrep 'ORA-121|ORA-01034'... (4 Replies)
I nedd help on the below highlited one.
can any one explain on this,How its work in shell scripting.. then that will be very great full...
L_ABCD=${L_DBG:=N}
Thanks
Muddasas (3 Replies)
Hi guys,
I'm currently writing a script for automating a FreeBSD ZFS setup (ZFSonRooT). I got stuck at one point for raidz(1,2 a.k.a raid5,6) and am in need of assistance.
This is what I need. example:
#!/bin/sh <- must stay sh
echo -n "hdd list: "
read hdd_list
echo -n "hdd label list:... (2 Replies)
I have file like below
summit hvar_rgrpd_10d_hvams17_ _kgr_prod.rec checksum checksum us europe
summit hvar_rgrpd_10d_hvams17_ _kgr_prod.xml var summit us ... (5 Replies)
Hi there
I am really struggling :eek: to place a value in a variable with the following loop, having run out of ideas please can someone point me in the right direction?
We first read two PIDs of a program (say calc) into an array, then we loop reading the details of those processes into a... (6 Replies)
not getting anywhere with this
an xml file contains multiple clients set up with same tags, different values.
I need to parse the file for client foo, and change the value of tag "64bit" from false to true.
cat clients.xml
<Client type"FIX">
<ClientName>foo</ClientName>... (3 Replies)
I'm trying to use awk to count the occurrences of two matching fields of a CSV file.
For instance, for data that looks like this...
Joe,Blue,Yes,No,High
Mike,Blue,Yes,Yes,Low
Joe,Red,No,No,Low
Joe,Red,Yes,Yes,Low
I've been trying to use code like this...
countvar=`awk ' $2~/$color/... (4 Replies)
In the awk below I am trying to output those lines that Match between file1 and file2, those Missing in file1, and those missing in file2. Using each $1,$2,$4,$5 value as a key to match on, that is if those 4 fields are found in both files the match, but if those 4 fields are not found then missing... (0 Replies)
Hi,
i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file
I have tried with join and awk and i keep getting blank outputs or same file
is there an easier way than what i am... (4 Replies)
Discussion started by: axis88
4 Replies
LEARN ABOUT OPENSOLARIS
mysqlshow
mysqlshow(1) MySQL database mysqlshow(1)NAME
mysqlshow
- Shows the structure of a mysql database (databases,tables and columns)
USAGE
shell> mysqlshow [OPTIONS] [database [table [column]]]
SYNOPSIS
mysqlshow [-#|--debug=...] [-?|--help] [-c|--character-sets-dir=...] [-C|--compress] [-h|--host=...] [-i|--status] [-k|--keys]
[-p|--password[=...]] [-P|--port=...] [-S|--socket=...] [-u|--user=#] [-V|--version]
DESCRIPTION
-#|--debug=...
output debug log. Often this is 'd:t:o,filename`
-?|--help
display help and exit
-c|--character-sets-dir=...
Directory where character sets are
-C|--compress
Use compression in server/client protocol
-h|--host=...
connect to host
-i|--status
Shows a lot of extra information about each table
-k|--keys
show keys for table
-p|--password[=...]
password to use when connecting to server If password is not given it's asked from the tty.
-P|--port=...
Port number to use for connection
-S|--socket=...
Socket file to use for connection
-u|--user=#
user for login if not current user
-V|--version
output version information and exit
NOTE
If last argument contains a shell or SQL wildcard (*,?,% or _) then only what's matched by the wildcard is shown. If no database is given
then all matching databases are shown. If no table is given then all matching tables in database are shown If no column is given then all
matching columns and columntypes in table are shown
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), mysql_zap(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
warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercur-
media.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 mysqlshow(1)