Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: Re: DBD::Pg INSERT enlightenment

by repson (Chaplain)
on Feb 06, 2001 at 13:47 UTC ( #56650=note: print w/replies, xml ) Need Help??


in reply to Re: DBD::Pg INSERT enlightenment
in thread DBD::Pg INSERT enlightenment

Another alternative is using a relational database system.

create table products ( prod_id int primary key, model_num int ); create table prod_desc ( prod_id int foreign key, desc text ); SELECT desc FROM products p, prod_desc d WHERE p.prod_id = d.prod_id A +ND p.prod_id = ?;
However that may be overkill for your purposes, and being no database and sql expert my syntax may not work (I only know mySQL and Access, and neither perfectly).

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://56650]
help
Chatterbox?
[Discipulus]: he does not learn, nor teach, nor learn
[planetscape]: hello all
[stonecolddevin]: o/ planetscape
[Sinistral]: I think that just the sight of his username now causes a downvote storm. I agree, and the gratuitous use of formatting does make reading hard. I've given him +1 on things where there seemed to be actual good advice, but I think the big
[Sinistral]: nail in coffin was the rant against a Schwarzian Transform
[stonecolddevin]: at best, from what i've seen, his knowledge is accurate up to maybe 2002. the sheer volume of words is mostly worthy of a downvote in most cases though i think
[erix]: ITYM Schwartzian Transform :P
[erix]: hey planetscape :)
[planetscape]: howdy stonecolddevin, erix
[Sinistral]: eric Aye. I thought I typed that wrong. All hail Randall! I listen to him on FLOSS Weekly

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (10)
As of 2017-06-22 20:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (530 votes). Check out past polls.