I don't believe I never thought of this.

[Anon]

I have a "delete user from database" script that I use on my site. This script just performs about 20 queries to delete the user from each table on my database.

And just now, I was sitting here and it occured to me that I can probably just do a single "DELETE FROM [databasename] WHERE [username]" query instead.

I can't get at my site right now (changing servers) but I am DYING to know if this is possible?

[twmcmahan]

Easier to keep it how it is... sometimes it's best to just use multiple queries...

My Favorite Principal: K.I.S.S.

Keep It Simple, Stupid.

[yelvington]

20 tables?

[Anon]

Nope. 21 in total. 🙂

[jc94062]

DELETE FROM [databasename] WHERE [username]
will not work