Bug #19003 Transpose table utility
Submitted: 11 Apr 2006 7:30 Modified: 24 Apr 2006 9:23
Reporter: Mark V Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:5.x OS:Windows (WinXP)
Assigned to: CPU Architecture:Any

[11 Apr 2006 7:30] Mark V 
Description:
Thanks for all the effort put into MySQL development.

I have found that a useful utility would be one that tranposes a table.
This would require the addition of columns that describe the original table column names and types.

Such a utility would require that bug #4117 (table column limit) be resolved.

This utility could be included into myisampack, or chck, or be a standalone utility.

The benefit is that outputting a transposed table, to say csv, etc. can result is substantially improved compression ratios.

How to repeat:
Feature request
[24 Apr 2006 9:23] Valeriy Kravchuk 
Thank you for a feature request. Yes, this kind of utility can be useful, rarely. But why not to implement it yourself, using Perl, for example? It is not a server task to transform data in such a way.