Creating a Table

Posted on 2000-04-26
Last Modified: 2010-04-27
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.


Question by:CODER
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Author Comment

ID: 2752130
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..

Expert Comment

ID: 2752475

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


Author Comment

ID: 2752513
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.
LVL 10

Expert Comment

ID: 2753196
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

Accepted Solution

davidleoy earned 100 total points
ID: 2765389
Dear Coder,

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

Alternatively, you could try this PERL script:

A sample txt file is available for the latter.

Hope it helps!!

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

this article is a guided solution for most of the common server issues in server hardware tasks we are facing in our routine job works. the topics in the following article covered are, 1) dell hardware raidlevel (Perc) 2) adding HDD 3) how t…
A clone is a duplicate copy. Sheep have been cloned and maybe someday even people will be cloned, but disk cloning (performed by the hard drive cloning software) is a vital tool used to manage and protect data. Let’s look at what hard drive cloning …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question