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
LATE(6) Games Manual LATE(6)
NAME
late - A simple game for one player.
SYNOPSIS
late [options]
DESCRIPTION
This manual page documents briefly the late game. This manual page was written for the Debian distribution because the original program
does not have a manual page. Instead, it has documentation in the GNU Info format; see below.
OPTIONS
This program does not follow the usual GNU command line syntax, only long options starting with two dashes (`-') are supported. A summary
of options is included below.
--help Show summary of options.
--version
Show version of program.
--cheat
Gives you infinite lives.
Playing
Your mouse is controls a sophisticated tool against evil: basically a fancy fancy tube. This is your weapon, a savage gillotine that cuts
up wallpaper with not a shred of hesitation nor remorse. It has but one weakness, it can only withstand a few impacts with balls.... For-
tunantly for you, the evil, heartless little balls also have a weakness, they can only travel across the original terrain and may be locked
up tight by its removal. And lock them up tight you must, for the only way to exact vengance from these ricocheting feinds is to choke
them out of existance. Your gillotine is sharp and quick, it may be shot out using the left button, and its orientation may be changed in
ninety degree increments with the right, but once you fire, there is no way to stop its cutting and razing until it has made its cut, or
been struck. The balls, in their spherical cunning have developed many tricks beyond just the contemptable bounce tactics of the simple
fireball, there are balls made from goo that divide and disperse when hit and can reform in an effort to confuse their prey. There are
unstable groups of three balls that will spontaniously explode when encapsulated tight enough. There are balls that will teleport for
suprise tactics. And even cold blooded balls that will be towards the cutters whenever they are seen.
You must fight these crewl balls, and you must prevail!
WEBSITE
The game has a website accessible at http://late.sourceforge.net/
The programs are documented fully by The Rise and Fall of a Fooish Bar, available via the Info system.
AUTHOR
This manual page was written by Steve Kemp <skx@debian.org>, for the Debian project (but may be used by others).
August 9, 2003 LATE(6)