Sponsored Content
Top Forums Shell Programming and Scripting mysql how to select a specific row from a table Post 302481982 by kpddong on Monday 20th of December 2010 10:22:59 AM
Old 12-20-2010
know this is late but thanks!
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

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

Select several minimum values from row (MySQL)

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

MySQL Master-Slave Configuration: Don't Replicate a Row of a Table?

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

Shell Script: Traverse Database Table Row by Row

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

Select 2 columns and transpose row by row

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

Moving new row and deleting old row to another table

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

In php, Moving a new row to another table and deleting old row

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

[Solved] Mysql - Take data from row and copy it to another row

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

awk to convert table-by-row to matrix table

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)
All times are GMT -4. The time now is 10:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy