[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Savannah-hackers] URGENT!!! Screwing up the database
From: |
Hugo Gayosso |
Subject: |
[Savannah-hackers] URGENT!!! Screwing up the database |
Date: |
30 Mar 2001 23:04:14 -0500 |
User-agent: |
Gnus/5.0808 (Gnus v5.8.8) Emacs/20.7 |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Shoot me now!
I was trying to change some permissions in order to allow GNATS
maintainer to join us, and I did the following:
select * from user_group where group_id = 65 and user_group_id = 364;
mysql> update user_group set admin_flags="A";
Query OK, 172 rows affected (0.06 sec)
Rows matched: 340 Changed: 172 Warnings: 0
SHIT!!, when I learned SQL, we did the select and then the update, and
the update worked only for that row (it doesn't seem to be the case
here), is there a way to roll out the changes?
I just raised everybody to administrator level!!!
I am sorry.
- --
Hugo Gayosso
Support the Free Software
Support the GNU Project
http://www.gnu.org
http://wildebeest.penguinpowered.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE6xVc9MNObVRBZveYRAlCWAJwIm6cwoFwa+jICQ1U791lFTpR+RgCfTb7p
Wr4ZVQtQ1xhDg2rtlfzgCUg=
=ojcY
-----END PGP SIGNATURE-----
- [Savannah-hackers] URGENT!!! Screwing up the database,
Hugo Gayosso <=