THANK YOU.
Someone finally asked the right question instead of answering the
original one.
Why would you possibly need 1,000 columns in a single table?
What are you trying to do?
Paul is probably correct and you don't really need to know how to create
a table
with a zillion columns 'easier' but you need to correctly normalize your
design.
Paul Tomblin wrote:
Quoting James Biggs ([EMAIL PROTECTED]):
Hi. My problem is that i want to create a table which should have around 1000
columns. Obviously, to add them manually would take a lot of time. Is there
a way to make this automatically? Any program or a command? I have looked
around but not much luck. Thanks for looking
99.99% of the time when somebody wants to make a table with that many
columns, it's because they don't understand relational databases and are
trying to put information that should be in a joined table into columns in
the main table.
