Re: How to overwrite existing file with SELECT .. INTO?

At 08:14 AM 4/13/2007, Amer Neely wrote: I'm using MySQL 5.0.21 and am trying to find out if it is possible to overwrite an existing file when using a 'SELECT ... INTO' command from the command line. Is there another parameter that can do this? I've looked through the online reference manual, b

rss2email

I'll be using for saving rss info. Just curious as to how others would do this, to avoid data entry. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: problem with Procedure and Cursor

Balaraju, When the line set pack='' is removed in favour of declare pack text default ''; MySQL 5.0.37 accepts the procedure. That looks like a MySQL bug. Will you report it, or shall I? When the sproc runs, the first NULL passed to CONCAT() sets pack to NULL. CONCAT_WS() ignores NULLs. Tha

Re: MySQL slave error when creating view

Sounds like a bug to me. It's likely fixed in newer versions; a lot of view/function/sproc replication bugs have been fixed. But if not, you should report it. Tim Lucia wrote: Nobody has any idea(s) on this? -Original Message- From: Tim Lucia [mailto:[EMAIL PROTECTED] Sent: Friday,

Re: a little user rights help?

Hi, Denise Wilson wrote: Hi. I'm brand new at this so I'm looking for a little help. I need to have two difference levels of access to a mysql database that I am developing for our librarians to use to maintain the various research resources we have available in our library. AdminType1 shou

Re: renaming database

Or if "RENAME DATABASE" is not implemented yet: CREATE newDatabase; then for each table in the oldDatabase issue: ALTER TABLE oldDatabase.tblX RENAME TO newDatabase.tblX After all is done: DROP oldDatabase -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer -- MySQL