Query in CENTOS Post: 302889099

Sponsored Content

Special Forums UNIX and Linux Applications Query in CENTOS Post 302889099 by shobana praveen on Wednesday 19th of February 2014 04:48:29 AM

02-19-2014

Registered User

Thank you

---------- Post updated at 04:48 AM ---------- Previous update was at 12:12 AM ----------

Thanks for your reply............it was helpful.

But I have another query like how to fetch only particular data from database (MYSQL)(for ex: user and msg) for every 2hrs and convert into an .xls format.

How to write script for the below query?

Code:

$arrAcc="SELECT accountID FROM account";
$Accountid=$DB->Execute($arrAcc);

for($i=0;$i<=length($Accountid);$i++)
{
$arrDevice="SELECT deviceID FROM device";
$Deviceid=$DB->Execute($arrDevice); 
for($j=0;$j<=length($Deviceid);$j++)
{
$arrEvent="SELECT * FROM eventdata WHERE accountID=$i and deviceID=$j";
$EventData=$DB->Execute($arrEvent);  
}
$j++;
}
$i++;

Thanks,
Shobana

Last edited by Franklin52; 02-19-2014 at 06:33 AM.. Reason: Please use code tags

shobana praveen

View Public Profile for shobana praveen

Find all posts by shobana praveen

6 More Discussions You Might Find Interesting

1. 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...

2. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the...

3. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ...

4. UNIX Benchmarks

2-cpu centos 5.7

BYTE UNIX Benchmarks (Version 3.11) System -- Linux centos1 2.6.18-274.17.1.el5xen #1 SMP Tue Jan 10 18:06:37 EST 2012 x86_64 x86_64 x86_64 GNU/Linux Start Benchmark Run: Fri Mar 2 19:42:41 EST 2012 2 interactive users. Dhrystone 2 without register variables 6929864.9 lps (10 secs,...

5. Red Hat

How to Upgrade Centos 5.7 using Centos 5.8 ISO image on Vmware workstation

Dear Linux Experts, On my windows 7 desktop with the help of Vmware workstation (Version 7.1), created virtual machine and installed Centos 5.7 successfully using ISO image. Query : Is this possible to upgrade the Centos 5.7 using Centos 5.8 ISO image to Centos version 5.8?.. if yes kindly...

6. Red Hat

RH V Centos

Hi, I have built out a new virtual production environment (VMWare, HA enabled, VMotion... all the bells & whistles) using RHEL5 VM's. I have got another ESX host that I plan to use as a pre-prod environment. To save some costs on RH subs I was thinking about installing this environment...

LEARN ABOUT CENTOS

grub-render-label

GRUB-RENDER-LABEL(1)                                               User Commands                                              GRUB-RENDER-LABEL(1)

NAME

       grub-render-label - generate a .disk_label for Apple Macs.

SYNOPSIS

       grub-render-label [OPTION...] [OPTIONS]

DESCRIPTION

       Render Apple .disk_label.

       -b, --bgcolor=COLOR
              use COLOR for background

       -c, --color=COLOR
              use COLOR for text

       -f, --font=FILE
              use FILE as font (PF2).

       -i, --input=FILE
              read text from FILE.

       -o, --output=FILE
              set output filename. Default is STDOUT

       -t, --text=STRING
              set the label to render

       -v, --verbose
              print verbose messages.

       -?, --help
              give this help list

       --usage
              give a short usage message

       -V, --version
              print program version

       Mandatory or optional arguments to long options are also mandatory or optional for any corresponding short options.

REPORTING BUGS

       Report bugs to <bug-grub@gnu.org>.

SEE ALSO

       The  full  documentation  for grub-render-label is maintained as a Texinfo manual.  If the info and grub-render-label programs are properly
       installed at your site, the command

              info grub-render-label

       should give you access to the complete manual.

grub-render-label (GRUB) 2.02-2ubuntu8.3                             July 2018                                                GRUB-RENDER-LABEL(1)