Re: Getting affected rows before executing query?
| From: | Jason Wong | Date: | Mon, 04 Nov 2002 06:06:40 +0000 |
| Subject: | Re: Getting affected rows before executing query? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22956@lists.php.net to get a copy of this message | ||
On Monday 04 November 2002 10:47, Leif K-Brooks wrote:
> I keep forgetting where clauses. It's my dumbest mistake, and I always
> make it. I just lost the password of everyone on my site trying to
> change my own - not good. Anyway, I'm trying to edit PhpMyAdmin to warn
> if there's more than a certain number of affected rows for a query. Is
> there a way to tell number of affected rows before executing the query?
AFAIK there isn't. What you can do are:
1) Get into the habit of writing WHERE clauses.
2) Write SELECT queries instead, once you're sure you've got it right change
it to a DELETE query.
3) Backup your database/tables before doing anything drastic.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Art is a jealous mistress.
-- Ralph Waldo Emerson
*/