From Schultheis Burkhard@burkhard.schultheis@web.de to comp.databases.mysql on Mon Nov 16 07:27:11 2020
From Newsgroup: comp.databases.mysql
I wanted to clean up the table mysql.user, because there were still
entries for hosts in it, which we don't have anymore. I wanted to type something like this:
DELETE FROM mysql.user WHERE host LIKE "nn.nn.nn%";
By mistake this became
DELETE FROM mysql.user WHERE user host LIKE "nn.nn.nn%";
Caused the exact opposite of what I intended, as if I had entered
DELETE FROM mysql.user WHERE host NOT LIKE "nn.nn.nn%";
Was fatal, of course. Can anyone figure out why the wrong statement made
such a mess?
This is mariadb 10.4.14.
Greetings
Burkhard
--- Synchronet 3.21d-Linux NewsLink 1.2
Who's Online
Recent Visitors
Jas Hud
Mon Nov 16 00:41:01 2026
from
Bbs.Eob-Bbs.Com,wi
via
Telnet
Geek2
Sun Nov 15 09:22:57 2026
from
Euclid, Oh
via
Telnet
Amr
Fri Nov 13 16:10:06 2026
from
Fayetteville, Nc
via
Telnet
Geek2
Fri Nov 13 13:11:13 2026
from
Euclid, Oh
via
Telnet