How to redisplay data from MySQL

Charles Alexander

Hello

I'm trying to redisplay and reorganize some data off a huge Excel
spreadsheet. I figured it would be easier to manipulate if I dumped the
data into MySQL with the help of phpMyAdmin.

I'm a newbie to MySQL and PHP and/or Perl so if someone can lead me in the
right direction to accomplish the following.

I have a database with 1 table from 5 columns of data.

Column 1 Column 2 Column 3 Column 4 Column 5

UniqueID A Param1 1Av1 1Av2 1Av3
UniqueID A Param2 2Av1 2Av2 2Av3
UniqueID A Param3 3Av1 3Av2 3Av3
UniqueID A ...
UniqueID A ...
UniqueID A ParamN Values of ParamN (")
UniqueID B Param1 1Bv1 1Bv2 1Bv3
UniqueID B Param2 2Bv1 2Bv2 2Bv3
UniqueID B Param3 3Bv1 3Bv2 3Bv3
UniqueID B ...
UniqueID B ...
UniqueID B ParamN Values of ParamN (")

UniqueID C Param1 1Cv1 1Cv2 1Cv3
UniqueID C Param2 2Cv1 2Cv2 2Cv3
UniqueID C Param3 3Cv1 3Cv2 3Cv3
UniqueID C ...
UniqueID C ...
UniqueID C ParamN Values of ParamN (")
I want to transpose these data to

Unique ID Param1 Param2 Param3 ... ParamN

A All Corresponding Values ie. v1, v2, v3 for each ID
B All Corresponding Values "
C All Corresponding Values "
The Pivot Table in Excel seems to be perfect for this except that I can't
get it to display the actual data values for each Unique ID as opposed to
Summaries, Count etc.

Any help would be appreciated.

Thanks

Charles

Jul 20 '05 #1

Subscribe Reply

1975

David L

i'm a bit confused by what you mean, but i doubt mysql will help you
very much. If i were in a similar situation, i'd persist with the Excel
pivot table, or, if some scripting is called for, i'd be using VBA in
Excel. For adhoc data manipulation, Access might be better.

Charles Alexander wrote:

Hello

I'm trying to redisplay and reorganize some data off a huge Excel
spreadsheet. I figured it would be easier to manipulate if I dumped the
data into MySQL with the help of phpMyAdmin.

I'm a newbie to MySQL and PHP and/or Perl so if someone can lead me in the
right direction to accomplish the following.

I have a database with 1 table from 5 columns of data.

Column 1 Column 2 Column 3 Column 4 Column 5

UniqueID A Param1 1Av1 1Av2 1Av3
UniqueID A Param2 2Av1 2Av2 2Av3
UniqueID A Param3 3Av1 3Av2 3Av3
UniqueID A ...
UniqueID A ...
UniqueID A ParamN Values of ParamN (")
UniqueID B Param1 1Bv1 1Bv2 1Bv3
UniqueID B Param2 2Bv1 2Bv2 2Bv3
UniqueID B Param3 3Bv1 3Bv2 3Bv3
UniqueID B ...
UniqueID B ...
UniqueID B ParamN Values of ParamN (")

UniqueID C Param1 1Cv1 1Cv2 1Cv3
UniqueID C Param2 2Cv1 2Cv2 2Cv3
UniqueID C Param3 3Cv1 3Cv2 3Cv3
UniqueID C ...
UniqueID C ...
UniqueID C ParamN Values of ParamN (")
I want to transpose these data to

Unique ID Param1 Param2 Param3 ... ParamN

A All Corresponding Values ie. v1, v2, v3 for each ID
B All Corresponding Values "
C All Corresponding Values "
The Pivot Table in Excel seems to be perfect for this except that I can't
get it to display the actual data values for each Unique ID as opposed to
Summaries, Count etc.

Any help would be appreciated.

Thanks

Charles

Jul 20 '05 #2

Similar topics

FW: mysql LOAD DATA INFILE

by: Donald Tyler | last post by:

Then the only way you can do it that I can think of is to write a PHP script to do basically what PHPMyAdmin is trying to do but without the LOCAL in there. However to do that you would need to...

MySQL Database

automating data entry

by: Jerry Weinstein | last post by:

Hi, I know about stored procedures and that they can speed up data entry via the SQL 'insert ' statement. However, one drawback to this method is that using the stored procedure still requires...

MySQL Database

Differences between DATA INFILE and LOAD DATA LOCAL INFILE ?

by: Ray in HK | last post by:

What are the differences between LOAD DATA INFILE and LOAD DATA LOCAL INFILE ? I found some web hosting company do not allow using LOAD DATA INFILE but allow LOAD DATA LOCAL INFILE. The reason...

MySQL Database

How can I get MySQL data from an external hard drive

by: eieiohh | last post by:

MySQL 3.23.49 PHP 4.3.8 Apache 2.0.51 Hi All! Newbie.. I had a CRM Open Source application installed and running. Windows Xp crashed. I was able to copy the contents of the entire hard...

MySQL Database

MySQL 5.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

by: jrs_14618 | last post by:

Hello All, This post is essentially a reply a previous post/thread here on this mailing.database.myodbc group titled: MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode I was...

PHP

text within textarea shifted after redisplay form

by: rukkie | last post by:

After a redisplay of the form, caused by errors in other fields, the text which is in the "Observ" textarea is shifted (some 8 places) to the right (and this each time after a redisplay). The code...

PHP

Redisplay data in DetailsView if error encountered during insert

by: Jim Coyne | last post by:

Is there a way to have the data controls re-populated with the previous data if an error was encountered during an insert? I currently have the following code to display the error message, but...

ASP.NET

Retaining checkbox state on redisplay

by: Jankie | last post by:

Greetings everyone ! I seek some help to retain checkbox state on redisplay.I only have one optional checkbox to indicate whether it's the user's first visit to the site Form1: <INPUT...

PHP

Error: "Column 'InvariantName' is constrained to be unique. Value 'MySql.Data.MySqlClient' is already present."

by: Carmine [www.thetotalsite.it] | last post by:

Hi, I am using ASP.Net 2.0 with the MySQL Connector .Net 5.1.2.2. I added these lines to the web.config to make the connector.net able to handle the SqlConnection object (and so to bind it to a...

ASP.NET

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp