Sponsored Content
Full Discussion: Query in CENTOS
Special Forums UNIX and Linux Applications Query in CENTOS Post 302889089 by Smiling Dragon on Tuesday 18th of February 2014 09:27:50 PM
Old 02-18-2014
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)
 

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... (0 Replies)
Discussion started by: hazno
0 Replies

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... (6 Replies)
Discussion started by: balaeswari
6 Replies

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 ... (2 Replies)
Discussion started by: DevendraG
2 Replies

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,... (0 Replies)
Discussion started by: ppchu99
0 Replies

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... (2 Replies)
Discussion started by: Ananthcn
2 Replies

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... (5 Replies)
Discussion started by: Duffs22
5 Replies
chpt(8) 						      System Manager's Manual							   chpt(8)

Name
       chpt - change a disk partition table

Syntax
       /etc/chpt [ -a ] [ -d ] [ -q ] [ -v ] [ [ -px offset size ] ... ] device

Description
       The  command  lets  you alter the partition sizes of a disk pack.  Using you can tailor your system disks and their partitions to suit your
       system's individual needs.

       If you want to create a file system on a partition that has been modified, you must use

       The standard procedure to change a partition table is:

       1. Look at the current partition table using the -q option.

       2. If a file system does not exist on the a partition, create one using the command.

	  If a file system exists on the a partition but does not contain a partition table in its superblock, copy the partition table  from  the
	  driver to the superblock using the command with the -a option.

       3. Change the partition offsets and sizes using the -px option.	You can change all the partitions for one pack on one command line.

       The  device  must be either the a or c partition of the raw device, depending upon where the file system resides.  For example, if the file
       system resides in the a partition of an RM05 in drive 0, device is rhp0a.

       A file system must exist on the a or c partition of the pack.  If you do not have a file system there, create one using

Options
       -a    Copies the partition table in the device driver to the disk pack.

       -d    Copies the default partition table to the disk pack and to the current partition table in the driver.  The default partition table is
	     the table that was built with the disk driver.

       -q    Runs without modifying the partition tables.  This prints the partition table of the specified disk pack.	It prints the default par-
	     tition table in the driver if there is no partition table on the disk pack.

       -v    Prints verbose messages showing the progress of

       -px   Changes the parameters of partition x on the disk pack to the specified offset and size.  x is the partition you are modifying (a, b,
	     c,  d,  e, f, g, or h).  Offset is the new beginning sector, and size is the new total number of sectors of the partition being modi-
	     fied.

Examples
       This example shows how to change the partition table on an RM05 disk pack in drive 1.  The commands in this example change the the size	of
       the h partition to include the g partition.  Comments are in parenthesis to the right of commands.
       % chpt -q /dev/rhp1a	(view partition table)
       /dev/rhp1a
       No partition table found in superblock...
       using default table from device driver.
       Current partition table:
       partition       bottom	    top      size    overlap
	   a		    0	  15883     15884    c
	   b		16416	  49855     33440    c
	   c		    0	 500383    500384    a,b,d,e,f,g,h
	   d	       341696	 357579     15884    c,g
	   e	       358112	 414047     55936    c,g
	   f	       414048	 500287     86240    c,g
	   g	       341696	 500287    158592    c,d,e,f
	   h		49856	 341201    291346    c
       %
       In  all	of  the tables generated by bottom is the offset (starting sector), top is the ending sector, and size is the number of sectors in
       the partition.  The overlap is the other sectors that are partially or entirely included in the partition.
       % bc		   (basic calculator)
       500287-49856	   (top of g minus bottom of h)
       450431
       450431+1 	   (add 1 because it is zero-based)
       450432		   (size of new h partition)
       %

       From the query, you can see that there is no partition table in the superblock of the a partition.  If this is because  there  is  no  file
       system in the a partition, run the command to create one.

       For this example, assume that there is a file system in the a partition of the disk, but the file system does not contain a partition table
       in its superblock.  Therefore, run with the -a option to copy the partition table in the driver to the superblock of the a partition.
       % chpt -a /dev/rhp1a	(add table to a partition)
       %

       Now you have a partition table to change.
       % chpt -v -ph 49856 450432 /dev/rhp1a   (change h)
       /dev/rhp1a
       New partition table:
       partition       bottom  top     size    overlap
	   a		    0	15883	15884  c
	   b		16416	49855	33440  c
	   c		    0  500383  500384  a,b,d,e,f,g,h
	   d	       341696  357579	15884  c,g,h
	   e	       358112  414047	55936  c,g,h
	   f	       414048  500287	86240  c,g,h
	   g	       341696  500287  158592  c,d,e,f,h
	   h		49856  500287  450432  c,d,e,f,g
       %

Caution
       Changing partition tables indiscriminately can result in losing large amounts of data.

       Check for file systems on all the partitions of the disk before using the -p option.  If a  file  system  exists  whose	partition  may	be
       destroyed, copy it to a backup medium.  After you have changed the partitions, restore the backed up file system.

Restrictions
       You must have superuser privileges to use

       You  can not shrink or change the offset of a partition with a file system mounted on it or with an open file descriptor on the entire par-
       tition.

       You can not change the offset of the a partition.

See Also
       ioctl(2), disktab(5), fsck(8), mkfs(8), newfs(8)
       Guide to System Disk Maintenance

																	   chpt(8)
All times are GMT -4. The time now is 05:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy