05-04-2012
My apologies.
It is working right. I messed up my echo command.
---------- Post updated at 02:55 PM ---------- Previous update was at 02:52 PM ----------
scrutinizer, this has definitely helped.
I need to work on the database queries to get me some other information.
When I do, I will attempt to use awk to fill in the rest of the spaces for the second lines (not the header one), so it has everything it needs.
I will take another look later, and post if I need more help.
Thanks!
I think this is the second or third time you have helped me out. I owe you for sure.
8 More Discussions You Might Find Interesting
1. Programming
Hi there,
I have a hierarchical database that include 4 tables. Table A is the parent of B, B is Parent of C, C is parent of D. If I want to query everything in D that is associated with A.name, how do I do that? Thanks!
YanYan (0 Replies)
Discussion started by: pinkgladiator
0 Replies
2. Shell Programming and Scripting
I would like to use the result of a query in another query. How do I redirect/add the output to another variable?
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result)) {
echo $row,"\n";
}
odbc_close($connect);
?>
This will output hostnames:
host1... (0 Replies)
Discussion started by: hazno
0 Replies
3. Shell Programming and Scripting
Hi all,
Does anyone know how to format the output from mysql from within a shell script?
i.e.
RESULT=`mysql command`
echo ${RESULT}
the ${RESULT} only displays the output on one line instead of how mysql would display it as columns etc (3 Replies)
Discussion started by: muay_tb
3 Replies
4. Web Development
hello all
i have 2 columns every column in the following format
column1
2011-04-01 11:39:54
column2
2019-02-03 00:00:00
i want get difference between above data as following
2 days 11:39
how to do so ?
i tried many functions but nothing works
please advice what is the query... (6 Replies)
Discussion started by: mogabr
6 Replies
5. Programming
Hello
i have created mysql query to compare to values and get difference in percentage
as following:
SELECT file_name, 100 - ((100 * (SELECT file_count FROM xipi_files z WHERE x.file_group = z.file_group AND x.file_name = z.file_name AND z.insert_date = CURDATE( ) - INTERVAL 1 DAY)) /... (1 Reply)
Discussion started by: mogabr
1 Replies
6. UNIX and Linux Applications
On psql
select titolo,lingua from titolo where titolo ~* 'brivid';
titolo | lingua
------- + ------
Brivido | 1
On Sqlplus/gqsql
SQL> select titolo,genere,anno,lingua from titolo where titolo like '%rivid%';
TITOLO... (6 Replies)
Discussion started by: Linusolaradm1
6 Replies
7. Programming
Hi All,
i have a table in mysql with the following data
Table name Test
Assettype Serial_No Status location
Mouse 123456 In Stock chennai
Mouse 98765 Allocated chennai
Keyboard ... (2 Replies)
Discussion started by: venkitesh
2 Replies
8. Shell Programming and Scripting
Hello,
In my shell script, I extract table data from HP Vertica DB into a csv file using vsql -c command. But the problem is the file getting created is in binary format and hence some of the data becomes unreadable which has chinese characters as part of data.
file -i filename.csv - gives... (2 Replies)
Discussion started by: Dharmatheja
2 Replies
LEARN ABOUT DEBIAN
pclock
PCLOCK(1) General Commands Manual PCLOCK(1)
NAME
pclock - pixmap clock
SYNOPSIS
pclock [options]
DESCRIPTION
This manual page documents briefly the pclock command. This manual page was written for the Debian GNU/Linux distribution because the
original program does not have a manual page.
pclock is a program that places a small analog clock program on the desktop of X. It was designed to run under the WindowMaker window man-
ager. It uses any 64x64 pixmap as a background.
OPTIONS
The programs follow the usual GNU command line syntax, with long options starting with two dashes (`-') and short optoins starting with one
dash. A summary of options is included below.
-B PIXMAP, --background=PIXMAP
Use the given pixmap as the clock background (size must be 64x64).
-H COLOR, --hands-color=COLOR
Draw the hands (hour, minute and second) in the specified color.
-S COLOR, --second-hand-color
Draw the second hand in the specified color
-h, --help
Show summary of options.
--hour-hand-length=INT
Draw the hour hand with the specified length of INT.
--minute-hand-length=INT
Draw the minute hand with the specified length of INT.
--second-hand-length=INT
Draw the second hand with the specified length of INT.
--second-hand-width=INT
Draw the minute hand with the specified width of INT.
-s, --second-hand
Don't display the second hand.
-v, --version
Show version of program.
-w, --withdrawn
Don't start up in a withdrawn (iconic) state.
AUTHOR
This manual page was written by Darren Benham <gecko@debian.org>, for the Debian GNU/Linux system (but may be used by others). The soft-
ware is copyrighted (c) 1998 by and released under the GPL v2.
Author: Alexander Kourakos <Alexander@Kourakos.com>
Web: http://www.kourakos.com/~awk/pclock/
PCLOCK(1)