Re: Deleting users

2001-07-27 Thread Jim Michaels
delete from mysql.user where mysql.user.user='somebody'; or use mysql; delete from user where user='somebody'; for a list of users, delete from user where user in ('somebody', 'anotherone', 'yetanother'); Jim Michaels - Original Message - From: Jerad Hampton [EMAIL PROTECTED] To: [EMAIL

Re: How do I get the query results I want?

2001-07-27 Thread Jim Michaels
,6,464,3,2,5,2 FAILED,7,468,0,2,5,2 FAILED,8,469,0,2,5,2 FAILED,21,636,6,0,0,1 Jim Michaels ([EMAIL PROTECTED]) - Original Message - From: Jim Matzdorff [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 27, 2001 11:33 AM Subject: How do I get the query results I want? lets say i have

Re: Mysql dumps FTP

2001-07-25 Thread Jim Michaels
(compressed), if I remember, takes a number of hours to compress and up to 3 days to send over a 100kbps WAN across the world. Oracle arch logs don't compress (maybe they are already compressed?). Jim Michaels ([EMAIL PROTECTED]) - Original Message - From: Stefan Hinz [EMAIL PROTECTED