Re: database strategy


Don't ask to ask, just ask
	PerlMonks

Re: database strategy

by Cine (Friar)

on Aug 03, 2002 at 01:12 UTC ( #187262=note: print w/replies, xml )

Need Help??

in reply to database strategy

I would suggest that you do it via two sql's

SELECT * FROM table a,table b WHERE a.id = b.id AND a.id IS NOT NULL A
+ND a.id != '';
and
SELECT * FROM table a,table b WHERE a.first_name = b.first_name AND a.
+last_name = b.last_name
AND (a.id IS NULL or a.id = '') AND (b.id IS NULL or b.id = '');
[download]

T I M T O W T D I

Comment on Re: database strategy Download Code

In Section Seekers of Perl Wisdom

Log In^?

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://187262]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others meditating upon the Monastery: (4)

As of 2023-02-07 22:18 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

I prefer not to run the latest version of Perl because:

Results (40 votes). Check out past polls.

Notices^?