changing the case of data

Hi all, Was wondering if someone had a solution. I have a database of image names that a PHP app points to. Some of the image names are upper case. Can anyone suggest the syntax of an Update statement that will change all Upper Case letters to lower?? Thanks, Frank -- This message has been

Version 4.1.1

Hi all, Does anyone know when MySQL 4.1.1 will be released? I was told that around November 15th. Well, it's almost December now. Thanks, Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: changing the case of data

On Nov 30, 2003, at 8:24 AM, Frank Surget wrote: Was wondering if someone had a solution. I have a database of image names that a PHP app points to. Some of the image names are upper case. Can anyone suggest the syntax of an Update statement that will change all Upper Case letters to lower??

V3.23 to V4

I have a version 3.23 database I want to put into version 4.0. I have used EMS Mysql manager to transfer the database from a version 3 environment to version 4 environment on different machines. When I start the GUI application I use MySQL with it says that the files need re-indexing and will not

Re: HELP!

- Original Message - From: Andy (da man) Rosenblatt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 29, 2003 4:05 PM Subject: HELP! hi I bought a book with your mySQL program and seemed to have installed it worng and i cant stop it. I never set a user name or a

designer

Do u know any programme that can degin databases in order to design before i implement them? It ll be very useful if the design was transformed to the correspondings create syntax? Thx - Do you Yahoo!? Free Pop-Up Blocker - Get it now

RE: designer

Hi try DEZIGN FOR DATABASES http://www.datanamic.com/ hth Peter -Original Message- From: Alaios [mailto:[EMAIL PROTECTED] Sent: 30 November 2003 20:27 To: [EMAIL PROTECTED] Subject: designer Do u know any programme that can degin databases in order to design before i implement them?

RE: designer

Do u know this one? It seems to be gpl http://www.fabforce.net/dbdesigner4/ Peter Lovatt [EMAIL PROTECTED] wrote:Hi try DEZIGN FOR DATABASES http://www.datanamic.com/ hth Peter -Original Message- From: Alaios [mailto:[EMAIL PROTECTED] Sent: 30 November 2003 20:27 To: [EMAIL

Counting total files

We have a database that has a quantity of files listed for each client record. We can count the number of clients, but how do we count the total number of files for all clients combined? -- Bruce Therrien [EMAIL PROTECTED] -- MySQL General Mailing List For list archives:

Re: Counting total files

Bruce Therrien wrote: We have a database that has a quantity of files listed for each client record. We can count the number of clients, but how do we count the total number of files for all clients combined? Rather than _count_, calculate that SUM. SELECT COUNT(client), SUM(fpc) FROM table

Locking one table blocks others

Fella's, First of all I'd like to welcome myself to this list. Have been here before, but now that I need your help again I decided to return. For the following question I've of course read the Manual, googled some .. Even checked the archives. Found no answer that satisfied me. For a website

How can I do phpmyadmin/mySQL web based DBase entries/queries?

I've been wanting to learn mySQL and phpmyadmin and make a website that enables me to make queries to my database and add information to the database. I'm not sure how I could go about doing this though. My main goal is to database all my software and then be able to access the database over

Mysql won't start

I'm using mysql on redhat 9 and wanted to enable the query log file.I copied one of the example my.cnf files to /etc and added an entry: --log to enable the log file but when I boot red hat I get a message that mysql started and ended. When I try to start mysql in a terminal window I get the same

Re: Mysql won't start

In the last episode (Nov 30), Michael Burke said: I'm using mysql on redhat 9 and wanted to enable the query log file.I copied one of the example my.cnf files to /etc and added an entry: --log to enable the log file but when I boot red hat I get a message that mysql started and ended. When I

Soundex in text searches

I am currently looking at trying to port an existing Informix application over to MySQL but I have fallen short on one particular feature. Under Informix using its text datablade, I can have a pattern match on the text search such that '+Tomas' would provide Thomas as well as Tomas. MySQL does not