RE: Spam
A little higher barrier to entry, even for non-spam posts might not be a bad thing. The list is already pretty well spammed with questions that are either in the manual, or result from a lack of programming experience in general. Making it harder to post might make it a little easier to stay subscribed --- jds [EMAIL PROTECTED] wrote: ummm. you go ahead with that and noone will stay on the list. again, now with my stupid reply, there has been more posts about spam than actual spam. let's do the list a favor and put this thread to bed. jOda -Original Message- From: Patrick Crowley [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 11:16 AM To: Keith C. Ivey Cc: MySQL List Subject: Re: Spam I have to say I'm shocked that the list is completely open. That's such a stupid newbie thing to do. Maybe we should initiate a spam strike until the list mom/dad listens. Just subscribe the list to *another* list, and watch the fun begin... best, patrick crowley mokolabs making sure the future doesn't suck... w http://mokolabs.com e [EMAIL PROTECTED] p 646.591.5477 Why *isn't* posting to the MySQL list restricted to subscribers? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Spam
I wasn't trying to say that the simple questions are spam, only that if it took a little more effort to post, some people might check with the manual and archives first. Posting to the list would always still be an option if those failed. Maybe the lists could be divided into: 1. mysql compilation and installation, 2. other mysql specific questions (table sizes, corruption recovery, database-level permissions, different table types), 3. writing applications w/mysql (like integrating w/other apps, php, odbc, and general questions about writing database apps, and writing particular sql statements). But it's not terrible as it is now. I would simply argue that making it slightly more difficult to post is *not* going to kill off the list. --- jds [EMAIL PROTECTED] wrote: i don't consider questions resulting from a lack of programming experience spam. the list SHOULD aid and embrace novice users. i know heikki and sinisa have both helped me with my basic questions, although i took some time to look in the archives and man before i posted. this IS the general list, after all. perhaps splitting it into three child lists: novice, intermediate, and advanced would be advisable. i dunno tho i wholeheartedly agree, though, that do my homework posts and questions easily located in the man or the lists archive are pretty prevalent here. j0da -Original Message- From: Robert Lucier [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 1:55 PM To: jds; Patrick Crowley; Keith C. Ivey Cc: MySQL List Subject: RE: Spam A little higher barrier to entry, even for non-spam posts might not be a bad thing. The list is already pretty well spammed with questions that are either in the manual, or result from a lack of programming experience in general. Making it harder to post might make it a little easier to stay subscribed --- jds [EMAIL PROTECTED] wrote: ummm. you go ahead with that and noone will stay on the list. again, now with my stupid reply, there has been more posts about spam than actual spam. let's do the list a favor and put this thread to bed. jOda -Original Message- From: Patrick Crowley [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 11:16 AM To: Keith C. Ivey Cc: MySQL List Subject: Re: Spam I have to say I'm shocked that the list is completely open. That's such a stupid newbie thing to do. Maybe we should initiate a spam strike until the list mom/dad listens. Just subscribe the list to *another* list, and watch the fun begin... best, patrick crowley mokolabs making sure the future doesn't suck... w http://mokolabs.com e [EMAIL PROTECTED] p 646.591.5477 Why *isn't* posting to the MySQL list restricted to subscribers? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http
Re: Changing part of field
I don't think you can do it with a single command. One fairly easy way is to run a command to generate the sql that will do the update. So your first statement will be something like: select concat( 'update mytable set emailaddress=''', emailaddress, '''where primary_key_column=', primary_key_column) substituting mytable and primary_key_column with your values. Output the results of that query to a file. Use your favorite text editor to do the actual replacement of the email address domain. Use mysql to run that file as a sql script. Update complete. --- Greg Peretti [EMAIL PROTECTED] wrote: I have what I hope is a simple problem, but being somewhat a novice at MySQL, it is a bit beyond me. I have a database that has a emailaddress field. A large number of the entries are from home.com, Excite's ISP. Since Excite is out of business, Comcast is converting them all to comcast.net next month. Is there a simple way to change all home.coms to comcast.nets while retaining the front part of each email address in our database? A link to the pertinent section of the manual would be most helpful. -- Greg Peretti web developer www.abqjournal.com (505) 823-3888 --- The web of our life is of a mingled yarn, good and ill together. - William Shakespeare - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
backup table required permissions
Hello, I've searched both the documentation and the mailing list archives but can't find the answer to this question (although several people seem to have asked it). Here goes: What permission grants are required to allow use of the backup table tablename to 'path' command? I can execute the command as root, but never as a non-root user, even when that user has grant all on db.* to username@localhost, and show grants verifies those permissions. I can successfully execute mysqlhotcopy as that non-root user, but have never gotten backup table to work. Any information would be appreciated. I would much prefer to use backup table so that I can execute the sql from within my existing application w/o requiring that perl be installed. Regards, Rob __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php