help with update query

I have a table, bowler_score_records, with the following columns: id, firstname, middlename, lastname, race, religion, email_address, bowling_score, gamedate As records get entered to this table, sometimes the users forget to input the email_address but the users always capture the full name, r

Re: Grant privs to multiple tables at once?

You can use the INFORMATION_SCHEMA.TABLES view to generate the GRANT statements for you. Write a query along these lines: SELECT CONCAT('GRANT SELECT ON test.', TABLE_NAME, ' to ''foouser'';') FROM INFORMATION_SCHEMA.TABLES WHERETABLE_SCHEMA = 'test' AND TABLE_NAME LIKE 'foo_

Re: Managing Excess Connections

Rolando, You are my hero! Thank you very much, this was extremely helpful. --- Rolando Edwards <[EMAIL PROTECTED]> wrote: > 1) Are you opening connections and properly (explicitly) > closing them ??? > > If you are using PHP, Please make sure you close all > mysql_query requests with two(2)

Re: storing images in the database

I've stored millions of images/files in mysql with minimal performance hit, performance loss is mostly based on your storage implementation. Checkout this article: http://www.dreamwerx.net/phpforum/?id=1 On 10/11/06, Greg Donald <[EMAIL PROTECTED]> wrote: On 10/10/06, Rodney Courtis <[EMAIL PRO

FW: Slow Access When Inserting Records

For your information, I updated my ODBC driver for mySQL to the latest version 3.51.12 and the slow connection problem has disappeared. From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: RE: Slow Access When Inserting RecordsDate: Thu, 12 Oct 2006 19:01:08 + Hi, I've tested the exact same ASP pa

Re: Managing Excess Connections

1) Are you opening connections and properly (explicitly) closing them ??? If you are using PHP, Please make sure you close all mysql_query requests with two(2) calls mysql_free_result mysql_close 2) Have you tried persistent connections ??? If you are using PHP, use mysql_pconnect instead of my

Re: Using posix users

Dan Nelson <[EMAIL PROTECTED]> writes: >> Is it possible to do the same with MySQL? > > Not yet, Argh! > but it being looked at: > > http://bugs.mysql.com/bug.php?id=4703 > http://forge.mysql.com/wiki/PluggableAuthenticationSupport Very good! Keep up the good work guys. I guess our students

Re: Using posix users

In the last episode (Oct 13), Yannick Gingras said: > I have a computer lab where students learn bioinformatics. The > courses include a crash course on database and we want to use MySQL > since it is a popular engine for bioinformatics. > > No one like to remember multiple passwords and since

Managing Excess Connections

I'm having an issue where an application will open multiple connections to mysql that will remain open. Eventually, the server will get bogged down with these connections or reach the max connections and stop allowing new connections. I'm working with the application vendor to resolve the issue o

Using posix users

Hi, I have a computer lab where students learn bioinformatics. The courses include a crash course on database and we want to use MySQL since it is a popular engine for bioinformatics. No one like to remember multiple passwords and since want each student to have its own MySQL user and databas