Sponsored Content
Top Forums Shell Programming and Scripting Need help getting my output from MYSQL query into right format Post 302635327 by brianjb on Friday 4th of May 2012 03:55:07 PM
Old 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

How to query one to many mysql

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

add the output of a query to a variable to be used in another query

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

Help needed to format mysql output

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

mysql query help

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

mysql query help

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

Please help: Oracle gqsql or sqlplus output format like mysql

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

Need help in mysql query

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

How to create a file from output of vertica table query in UTF-8 format?

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
INEWS(1)                                                      General Commands Manual                                                     INEWS(1)

NAME
inews - send a Usenet article to the local news server for distribution SYNOPSIS
inews [ -h ] [ -D ] [ -O ] [ -R ] [ -S ] [ header_flags ] [ input ] DESCRIPTION
Inews reads a Usenet news article (perhaps with headers) from the named file or standard input if no file is given. It adds some headers and performs some consistency checks. If the article does not meet these checks (for example, too much quoting of old articles, or posting to non-existent newsgroups) then the article is rejected. If it passes the checks, inews sends the article to the local news server as specified in the inn.conf(5) file for distribution. OPTIONS
-h In the standard mode of operation, the input consists of the article headers, a blank line, and the message body. For compatibility with older software, the ``-h'' flag must be used. If there are no headers in the message, then this flag may be omitted. -O The default Organization header will be provided if none is present in the article or if the ``-o'' flag is not used. To prevent adding the default, use the ``-O'' flag. -D As a debugging aide, if the ``-D'' flag is used, the consistency checks will be performed, and the article will be sent to the stan- dard output, rather then sent to the server. -A -V -W For compatibility with C News, inews accepts, but ignores, the ``-A'', ``-V'' and ``-W'' flags. -N The C News ``-N'' flag is treated as the ``-D'' flag. -S If a file named .signature exists in the user's home directory, inews will try to append it to the end of the article. If the file cannot be read, or if it is too long (for example, more than four lines or one standard I/O buffer), or if some other problem occurs, then the article will not be posted. To suppress this action use the ``-S'' flag. -R If the ``-R'' flag is used then inews will reject any attempts to post control messages. header_flags Several headers may be specified on the command line, shown in the synopsis above as header_flags. Each of these flags takes a sin- gle parameter; if the value is more than one word (for example, almost all Subject lines) then quotes must be used to prevent the shell from splitting it into multiple words. The options, and their equivalent header, are as follows: a Approved c Control d Distribution e Expires f From w Followup-To n Newsgroups r Reply-To t Subject F References o Organization x Path prefix If the ``-x'' flag is used, then its value will be the start of the header. Any other host will see the site in the header, and therefore not offer the article to that site. The Path will always end not-for-mail. NOTES
If an unapproved posting is made to a moderated newsgroup, inews will try to mail the article to the moderator for posting. It will query the remote news server for a moderators listing. If that doesn't succeed, it will fallback to using the local moderators(5) file to deter- mine the mailing address. If no address is found, it will use the inn.conf file to determine a ``last-chance'' host to try. If the NNTP server needs to authenticate the client, inews will use the NNTPsendpassword(3) routine to authenticate itself. In order to do this, the program will need read access to the passwd.nntp(5) file. This is typically done by having the file group-readable and making inews run setgid to that group. Inews exits with a zero status if the article was succesfully posted or mailed, or with a non-zero status if the article could not be delivered. Since inews will spool its input if the server is unavailable, it is usually necessary to run rnews(1) with the ``-U'' flag on a regular basis, usually out of cron(8). HISTORY
Written by Rich $alz <rsalz@uunet.uu.net> for InterNetNews. This is revision 1.27, dated 1996/10/29. SEE ALSO
moderators(5), inn.conf(5). rnews(1). INEWS(1)
All times are GMT -4. The time now is 11:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy