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
--
View this message in c
James Biggs <[EMAIL PROTECTED]> was heard to say:
>
> 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
I can do for example
$dbh->do( "CREATE TABLE my_table (etc etc etc)");
but i don't know a Perl command for creating a table with many columns. I
did not find one in the docs either. Thanks
--
View this message in context:
http://www.nabble.com/Creating-a-%28really%29-big-table-t1096710.html#a2
James Biggs <[EMAIL PROTECTED]> was heard to say:
>
> I can do for example
>
> $dbh->do( "CREATE TABLE my_table (etc etc etc)");
>
> but i don't know a Perl command for creating a table with many columns. I
> did not find one in the docs either. Thanks
>
Something along these lines (untested!!) s
Markus Hoenicka <[EMAIL PROTECTED]> was heard to say:
Sorry for the typo, fixed below
my $command = "CREATE TABLE my_table (";
foreach my $counter (1..999) {
$command .= "INT column" . $counter . ", ";
}
$command .= "INT column1000)";
print $command;
--
Markus Hoenicka
[EMAIL PROTECTED]
(
On Feb 10, 2006, at 13:01, James Biggs wrote:
I can do for example
$dbh->do( "CREATE TABLE my_table (etc etc etc)");
but i don't know a Perl command for creating a table with many
columns. I
did not find one in the docs either. Thanks
The idea is that you build the SQL string dynamically
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 lu
On Fri, Feb 10, 2006 at 07:44:37AM -0500, 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 auto
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'
On 2/10/06, m christensen <[EMAIL PROTECTED]> wrote:
> 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?
Most people ask the little questions and don't give you the "big picture".
A lot
ary 10, 2006 11:12 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Creating a (really) big table
>
>
> On 2/10/06, m christensen <[EMAIL PROTECTED]> wrote:
> > THANK YOU.
> >
> > Someone finally asked the right question instead of answering the
>
On 2/10/06, Fred Williams <[EMAIL PROTECTED]> wrote:
> Well, unfortunately our bid'ness seems to be a "contact sport" for many.
> I have been guilty of pretty much the same more times than I am proud
> of. That said...
>
> The question is quite valid. I do agree that something must be amiss if
>
Jay Sprenkle wrote:
On 2/10/06, Fred Williams <[EMAIL PROTECTED]> wrote:
Well, unfortunately our bid'ness seems to be a "contact sport" for many.
I have been guilty of pretty much the same more times than I am proud
of. That said...
The question is quite valid. I do agree that something m
13 matches
Mail list logo