savannah-hackers
[Top][All Lists]
Advanced

[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-----



reply via email to

[Prev in Thread] Current Thread [Next in Thread]