• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

Creating a Table

Hello I would like to know how to create a Table in PERL.
What I am not sure abt is that:  is there a perl command that can allow me to do this or is an sql statment involved or some DBI command.

Thanks.  
PS: I NEED THIS LIKE YESTERDAY!!!!

0
CODER
Asked:
CODER
1 Solution
 
CODERAuthor Commented:
Basically I need to open diff databases specified in a file and then I want to create a temp table.  so if you could ans the quest.  I would really appreciate it.

THanks again..
0
 
Ace_coreyCommented:
Heh CODER,

You really need to be a bit more specific when you ask questions like this.

First of all, what are you trying to do?  writing a script for the net?  ODBC?  What kind of DB are you using?  Why PERL?

If you can clarify your question, I will try to help

Corey
0
 
CODERAuthor Commented:
well Ace_corey  what i need to do is open a bunch of databases and then i need to create a temp table where i would store some info.

Now this is ultimately for a web application.
It is a script that will work for othere and be used for a web application.

THanks Ace_corey

I hope u could help me...

ps: this has to be in PERL cause that is what we use here.
0
 
tonnybrandtCommented:
I haven't got any experiance in perl whatsoever, but i've made a lot of Temp tables in sql, so here's a suggestion:

Select * from costumer_tbl into temp consumer_tmp;

You can now use it as any other normal table, as long that you're using it in the same session.

When finished using it remember to:
drop table consumer_tmp;


Hope this helps
0
 
davidleoyCommented:
Dear Coder,

This link would help you create the table you require on the fly:

http://technotrade.com/table/table.html

Alternatively, you could try this PERL script:

http://www.netexpress.net/~mkruse/www/scripts/table.html

A sample txt file is available for the latter.

Hope it helps!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Building an Effective Phishing Protection Program

Join Director of Product Management Todd OBoyle on April 26th as he covers the key elements of a phishing protection program. Whether you’re an old hat at phishing education or considering starting a program -- we'll discuss critical components that should be in any program.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now