I need a solution
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.
PS: I NEED THIS LIKE YESTERDAY!!!!
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.
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
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.
I hope u could help me...
ps: this has to be in PERL cause that is what we use here.
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
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!!
Solve your biggest tech problems alongside global tech experts with 1:1 help.
Tackle projects and never again get stuck behind a technical roadblock.
How it Works
Plans and Pricing
Become an Expert
Who We Are
Join Our Team
Hall of Fame
Experts Exchange, LLC.
All rights reserved. Covered by US Patent.