12-20-2010
know this is late but thanks!
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.)
I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies
2. Programming
Hello there.
I've got the query like that
SELECT count(tour_id) AS cnt
FROM orders
JOIN tours
ON orders.tour_id=tours.id
GROUP BY tour_id
The result Is
cnt
1
4
2
1
1
Now i have to select all records with minimum values in field "cnt"
MySQL function min() returns only one.... (2 Replies)
Discussion started by: Trump
2 Replies
3. Web Development
Anyone have a clue about this?
I have checked the MySQL documentation and it does not seem possible to exclude a row of a table from replication between Master and Slave. It seems that replication in MySQL can only be managed at the table level, not at the row level.
Does anyone know a work... (5 Replies)
Discussion started by: Neo
5 Replies
4. UNIX for Dummies Questions & Answers
Hello Everyone,
My issue is that I want to traverse a database table row by row and do some action on the value retrieved in each row.
I have gone through a lot of shell script questions/posts. I could find row by row traversal of a file but not a database table.
Please help.
Thanks &... (5 Replies)
Discussion started by: ahsan.asghar
5 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have a tab-delimited file as follows:
1 1 2 2 3 3 4 4
a a b b c c d d
5 5 6 6 7 7 8 8
e e f f g g h h
9 9 10 10 11 11 12 12
i i j j k k l l
13 13 14 14 15 15 16 16
m m n n o o p p
The output I need is:
1 1 a a 5 5 e e 9 9 i i 13... (5 Replies)
Discussion started by: mvaishnav
5 Replies
6. Shell Programming and Scripting
Hi, I want to move a new row to another table if the field from new row doesn't have the first word that I categorized (like: IRC blablabla, PTM blablabla, ADM blablabla, BS blablabla).
I already use this script but doesn't work as I expected.
CHECK_KEYWORD="$( mysql -uroot -p123456 smsd -N... (7 Replies)
Discussion started by: jazzyzha
7 Replies
7. Shell Programming and Scripting
Hi, I already succeed moving a new row to another table if the field from new row doesn't have the first word that I categorized (like: IRC blablabla, PTM blablabla, ADM blablabla, BS blablabla).
But it can't delete the old row. Please help me with the script.
my php script:
INSERT INTO... (2 Replies)
Discussion started by: jazzyzha
2 Replies
8. Emergency UNIX and Linux Support
Sorry if I repost my question in this section, but I'm really in a hurry since I have to finish my work... :(
Dear community,
I have a table with two rows like:
Row1 Row2
======= =======
7,3 text 1
1,3 text 2
1,2,3 blabla
What i need to do is add/copy... (2 Replies)
Discussion started by: Lord Spectre
2 Replies
9. Shell Programming and Scripting
Hello,
I need some help to reformat this table-by-row to matrix?
infile:
site1 A:o,p,q,r,s,t
site1 C:y,u
site1 T:v,w
site1 -:x,z
site2 A:p,r,t,v,w,z
site2 C:u,y
site2 G:q,s
site2 -:o,x
site3 A:o,q,s,t,u,z
site3 C:y
site3 T:v,w,x
site3 -:p,routfile:
SITE o p q r s t v u w x y... (7 Replies)
Discussion started by: yifangt
7 Replies
LEARN ABOUT DEBIAN
namazu
NAMAZU(1) Namazu Project NAMAZU(1)
NAME
namazu - a search program of Namazu
SYNOPSIS
namazu [options] <query> [index]...
DESCRIPTION
namazu 2.0.21, a search program of Namazu.
-n, --max=NUM
set the number of documents shown to NUM.
-w, --whence=NUM
set the first number of documents shown to NUM.
-l, --list
print the results by listing the format.
-s, --short
print the results in a short format.
--result=EXT
set NMZ.result.EXT for printing the results.
--late sort the documents in late order.
--early
sort the documents in early order.
--sort=METHOD
set a sort METHOD (score, date, field:name)
--ascending
sort in ascending order (default: descending)
-a, --all
print all results.
-c, --count
print only the number of hits.
-h, --html
print in HTML format.
-r, --no-references
do not display the reference hit counts.
-H, --page
print the links of further results. (This is nearly meaningless)
-F, --form
force to print the <form> ... </form> region.
-R, --no-replace
do not replace the URI string.
-U, --no-decode-uri
do not decode the URI when printing in a plain format.
-o, --output=FILE
set the output file name to FILE.
-f, --config=FILE
set the config file name to FILE.
-C, --show-config
print the current configuration.
-q, --quiet
do not display extra messages except search results.
-d, --debug
be in debug mode.
-v, --version
show the namazu version and exit.
--help show this help and exit.
--norc do not read the personal initialization files.
-- Terminate option list.
REPORTING BUGS
Report bugs to <http://www.namazu.org/trac-namazu/trac.cgi> or <bug-namazu@namazu.org>.
COPYRIGHT
Copyright (C) 1997-1999 Satoru Takabayashi All rights reserved.
Copyright (C) 2000-2009 Namazu Project All rights reserved.
This is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MER-
CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
namazu of Namazu 2.0.21 July 2011 NAMAZU(1)