Re: changing the case of data

s to lower?? UPDATE MyTable SET MyField = LOWER(MyField) ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

help getting started. While the number of subscribers there are small, they are growing, and the atmosphere is very much like this list. Check 'em out at http://leafe.com/mailman/listinfo/prolinux and http://leafe.com/mailman/listinfo/propython, respectively. ___/ / __/ / /

Re: Installing Mysql on Panther

ystem Preferences, and turn off Web Sharing in the "Sharing" preference pane. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECT Optimization (speeding up a SELECT)

h the LIKE expression? Are you trying to find a single percent sign? ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Forms & Reports like I use in MS Access

OS X that I'm sure others will chime in with. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Multiple Roles

is then a matter of joining the person table to the role table through the allocation table to get a list of all roles for a given person. Reversing the queries then gives you all people who have a given role. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount

Re: Oracle nvl function equivalent.

is called IFNULL(). ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: transaction support

I would be very suspicious of anyone who tailors a solutions to his needs instead of yours. I'd not only consider using MySQL, I'd consider looking for a different developer. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umou

Re: sloooow sql query

`date` field? ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL2000 and MySql

is one of the fastest engines for local manipulation of data. I frequently use Visual FoxPro to grab data from a MySQL database, make the updates locally, and then pump the changes back. VFP rocks with MySQL! ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech

Re: SQL2000 and MySql

de, the VFP community has never really integrated into the whole Microsoft "way" of doing things. There is a large group of developers who develop business apps for Windows desktops in VFP, and use MySQL on Linux servers for the data. At a recent VFP conference, a session on using My

Re: SQL2000 and MySql

would dream of trading the security and scalability of MySQL for a couple of milliseconds of improved performance. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Newbie Question

ot helping that goal. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem with regexp

gt; pat = '([\(][Oo][Tt][ \]\)])' >>> tx = 'This is an (OT) Test' >>> re.search(pat, tx).groups() ('(OT)',) But in MySQL, I don't match: mysql> select 'This is an (OT) Test' regexp '[\(][Oo][Tt][ \]\)]' as mtch; +--+ |

Re: Problem with regexp

On Feb 28, 2004, at 10:33 AM, Michael Stassen wrote: In the meantime, perhaps the following will help: mysql> select 'This is an [OT] Test' regexp "[ [:punct:]]OT[ [:punct:]]" as mtch; Hey, thanks - that works! ___/ / __/ / / Ed Leafe

Re: Doing a count of a count in mysql

particular count. Repeat that for each count, and join the statements with UNION. For more than a few possible counts, though, I'd probably use a temporary table, and do a second select from that. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.co

Re: mySQL GUIs

On Thursday, June 12, 2003, at 10:44 AM, Justin wrote: Anybody have any recommendations for one that runs on Mac OS X? I use phpMyAdmin to manage several MySQL databases, both on my LAN and over the internet. Way cool and powerful! ___/ / __/ / / Ed Leafe http://leafe.com

Re: Full text search

will match only those records with 'word' at the end of the field. With '%word%', it will match if 'word' appears anywhere in the field. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: very long query time

from java programs. Perhaps telling us what the query is might help with a solution. Adding the proper index might speed things up dramatically; sometimes re-wording the query can also help. ___/ / __/ / ____/ Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL Ge

Re: Stuck with Tutorial

On Friday, July 4, 2003, at 12:27 PM, Richard Grubb wrote: SELECT * FROM pet WHERE birth >= "1998-1-1"; Try: SELECT * FROM pet WHERE birth >= "1998-01-01"; You need 2 characters for the day and month fields. ___/ / __/ / / Ed Leaf

Re: What's up with this GATOR crap?

-back installation to 3rd parties, many of which install spyware, and Gator is one of the most common. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: does mySQL support a boolean data type?

7; and would like to cut down on the storage. I use tinyint, and populate the fields with either 1 or 0 for True and False, respectively. This translates well to languages such as Python, which also use 1 and 0 to indicate boolean states. ___/ / __/ / / Ed Leafe htt

Re: Working with the text datatype in Mysql

the net but couldn't find more information about what might be causing the problem... How are they typing in the information? From a web page? From the command line? From a custom program? ___/ / __/ / ____/ Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL Ge

Re: how listen queue size affect MySQL on RedHat

, I've read the dire warnings about munging Reply-To: headers, but none of them make any valid points. I've run and participated in many lists, and have never had a problem with defaulting replies to the list. ___/ / __/ / / Ed Leafe http://leafe.

Re: INDEX'd fields...any drawbacks?

ning under. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Select match from a stored delimitated string?

pieces for a given project as it is to get all the projects a given piece belongs to. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Possible regexp bug in 4.1a?

--+--+-+ | 1 | 1 |1 | FOO | FOO | foo | +---+---+--+--+--+-+ 1 row in set (0.37 sec) I've tried variations on this query, and it seems that nesting two functions as the argument to regexp causes the match to fail. Am I missing something obvious, or

Re: Text fields

how do i append text to a field. (I can tune server parameter max_allow_packet , but that's not a good option) update mytable set textfield = textfield + newchunk where pk = [ your pk ] ___/ / __/ / ____/ Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL Ge

Re: 1000 rows in MySQLcc

your queries. The 1000 limit only kicks in as a default. ___/ / __/ / ____/ Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Like MySQL Dump, but with FoxPro Tables

for you. It is available for free on my website: http://leafe.com/dls/vfp ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Convert Foxpro database to Mysql

On Saturday, October 4, 2003, at 11:05 AM, Dwi Suharto Panese wrote: i want to convert the existing foxpro database into mysql database. Any idea? Sure, I've done it a lot. What exactly do you need to know? ___/ / __/ / ____/ Ed Leafe http://leafe.com/

Re: secure automated access (was "Re: Backing up all databases")

password" This is incorrect, unless the double quotes are part of the password. Removing them so that the entry reads: [client] password=mysql_root_password will correct the problem. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sl

Re: secure automated access (was "Re: Backing up all databases")

iguring that the manual was worded incorrectly; i.e., that double-quotes were only to be used when the password contained comment characters. I'm using 4.1.0-alpha running on RH *, if that makes any difference. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;

Re: How do test unique values in a MySql column?

ear only once in the table: SELECT txtName FROM MyTable GROUP BY txtName HAVING count(*) = 1 ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: SHOW TABLE STATUS without LIKE

;Reply All" functionality). So as long as the list admins configure the list this way, you have to expect a large number of these sort of problems. It's their choice to fix it or not. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;u

Re: Index before or after inserts?

index. Otherwise, the indexes have to be updated with each and every insert. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Where is the COMPRESS() function?

is an error in the docs? ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]