MySQL Forums
Forum List  »  MyISAM

Re: Large number of columns causing - Unknown Error
Posted by: Maciej Wo?niak
Date: March 01, 2010 06:58AM

Hey I transpose the first table. I have

DATE_FIELD | SOMEOBJECTNAME | VALUE_A | VALUE_B | etc..

And I convert it to

DATE_FIELD | SOMEOBJECTNAME_VALUE_A | SOMEOBJECTNAME_VALUE_B | etc...

Thats why I get such a hilarious number of columns.
I use this in order to provide data to a web page containing a grid (ExtJS). I know I shouldnt actually use a database for this but rather a flat file + some coding on the server side but database gives me all the data configurability I need. I have tried diffrent approaches like having a ID | OBJECT NAME | VALUE | DATE_FIELD but this died with a zilion JOIN's thats why I decided having a lame flat table is the way to go.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Large number of columns causing - Unknown Error
2200
March 01, 2010 06:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.