Query in CENTOS Post: 302889089

Sponsored Content

Special Forums UNIX and Linux Applications Query in CENTOS Post 302889089 by Smiling Dragon on Tuesday 18th of February 2014 09:27:50 PM

02-18-2014

Registered User

I'm guessing you are talking about extracting data from a MySQL database and putting it into a spreadsheet?
In which case you'd start with a call to mysql:

Code:

mysql -d databasename -u username -ppassword -e 'SELECT datas FROM Event'

You'd then need to parse this data into a csv style format (piping the mysql into awk is a pretty easy way to get this done, but mysql might even have a csv output format option if you explore it's help pages)
Lastly, have a look round for csv to xls converters (or just stick with .csv format as excel will happily read that)

Smiling Dragon

View Public Profile for Smiling Dragon

Find all posts by Smiling Dragon

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 XFREE86

vmware

VMWARE(4)						     Kernel Interfaces Manual							 VMWARE(4)

NAME

       vmware - VMware SVGA video driver

SYNOPSIS

       Section "Device"
	 Identifier "devname"
	 Driver "vmware"
	 ...
       EndSection

DESCRIPTION

       vmware is an XFree86 driver for VMware virtual video cards.

CONFIGURATION DETAILS

       Please refer to XF86Config(5) for general configuration details.  This section only covers configuration details specific to this driver.

       The driver auto-detects the version of any virtual VMware SVGA adapter.

       The following driver Options are supported:

       Option "HWCursor" "boolean"
	      Enable or disable the HW cursor.	Default: off.

       Option "NoAccel" "boolean"
	      Disable or enable acceleration.  Default: acceleration is enabled.

SEE ALSO

       XFree86(1), XF86Config(5), xf86config(1), Xserver(1), X(7)

AUTHORS

       Copyright (c) 1999-2001 VMware, Inc.

XFree86 							   Version 4.7.0							 VMWARE(4)