How to create a table with 300 columns?

Hello

I have created tables with 20-30 columns and it was manually writing each line of code even when the col type was the same such as
But how can I create a table with 300 columns? Is there a proper way other than manually writing each line as in the above example?

Please help
mr

re: How to create a table with 300 columns?

Heya, MR. Welcome to TSDN!

Please use CODE tags when posting source code. See the REPLY GUIDELINES on the right side of the page next time you post.

You may want to rethink your table structure. For example, you can save each sample as its own record:
Each id will then have 300 rows, which is fine because MySQL is good at indexing. You'd just need another script, such as PHP, if you wanted to present your data horizontally.

To answer your question, though, if you want 300 columns, you need to declare all 300 of them.

re: How to create a table with 300 columns?

--------------------------------
Hello,

Thank you for your message. I guess there is no nice solution because basically my data is a 16000 x 300 matrix. so, it doesn't help to transpose it..:)

re: How to create a table with 300 columns?

Heya, MR.

Depends on where your data is coming from. Are you saving the data using another scripting language, such as PHP or ASP?

re: How to create a table with 300 columns?

----------------------------------------------------------------
Hello

My data is in .txt format. I cannot open it in excel as it exceeds 256 columns. The data itself came from a gene expression scan.

Thank you
mray