UserFriendly Strip Comments


	The Daily Static UF Archives Register UF Membership Ad Free Site Postcards Community Geekfinder UFie Gear Advertise on UF Forum Rules & FAQ Username Password Create a New Account

Back to UserFriendly Strip Comments Index

MySql: record exists	by mikosullivan	2002-11-01 10:57:10
A question for the MySql 'rus: what's the most effective way to check if a record simply exists? Let's say I have a table called `patients` with a primary key of `pat_pk`. What's the most efficient way to find out if a record with primary key of, say, 1000 exists?
[ Reply ]
I just	by fireballmatt	2002-11-01 10:58:09
I dont' know all the syntax...	by krupa	2002-11-01 11:08:11
One note. The second SELECT is faster.	by Avium	2002-11-01 11:33:24
And wouldn't it be even faster yet	by webishop	2002-11-01 12:08:07
Yep. Missed that one.	by Avium	2002-11-01 12:36:43
Does it have the exists function?	by borg389	2002-11-01 11:22:09
Depends on your real need.	by Yohimbe	2002-11-01 12:42:21
Duuuh	by Yohimbe	2002-11-01 13:15:27

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)