Solved

Creating a Table

Posted on 2000-04-26
5
183 Views
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.

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

0
Comment
Question by:CODER
5 Comments
 

Author Comment

by:CODER
Comment Utility
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
 

Expert Comment

by:Ace_corey
Comment Utility
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
 

Author Comment

by:CODER
Comment Utility
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
 
LVL 10

Expert Comment

by:tonnybrandt
Comment Utility
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
 
LVL 1

Accepted Solution

by:
davidleoy earned 100 total points
Comment Utility
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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In this article you will get to know about pros and cons of storage drives HDD, SSD and SSHD.
What do we know about Legacy Video Conferencing? - Full IT support needed! - Complicated systems at outrageous prices! - Intense training required! Highfive believes we need to embrace a new alternative.
This video discusses moving either the default database or any database to a new volume.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

771 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now