On Sat, Jul 6, 2013 at 8:06 AM, Purushothaman <[email protected]> wrote:
> >here in excel i am able to add dates in columnwise. > >but in mysql each record is added rowwise. > >Is there is any way to add datas coulmnwise in mysql > The correct way of storing time-series data in a RDBMS (mysql, postgres...) is channels in cols and data in rows only. Typically RDBMSs can handle millions of rows but not columns. Imagine running your data acquisition over years. Also updating a single row with channels in rows will be a nightmare and may not be even possible. > >otherwise if datas are rowwise any query can be created to > display tables vertically. > No you cannot. If you are writing a full fledged php application, you can query the data normally, load it into an array and transpose it to get the required results. Take a look at this: http://stackoverflow.com/questions/797251/transposing-multidimensional-arrays-in-php If you only want to present data (manually), install phpmyadmin and export your required data (got through a SQL query or search option) to Excel formal. Load this excel file, copy the required cells and use the paste-special>Transpose function. Regards, Arun Venkataswamy http://wondroussky.blogspot.in/ "கற்றது கைமண் அளவு, கல்லாதது உலகளவு" - ஔவையார் Known is a drop, Unknown is an ocean _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc ILUGC Mailing List Guidelines: http://ilugc.in/mailinglist-guidelines
