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
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
