Re: Broken Mac pref panel

On Sunday 04 June 2006 20:38, Marcus Bointon scribble on about: > On 4 Jun 2006, at 23:25, Marcus Bointon wrote: > > I'm having trouble with the prefpane in OS X > > It seems I'm not alone - there are several reports of this in the > MySQL bug tracker. Looks like a bug in the prefpane: > > http://b

Re: Fun with Dates and Incentives.

On Wednesday 24 May 2006 15:18, Brian Menke scribble on about: > Peter, thanks for the detailed info. I will figure out how to get rid of > the UNIQUE key. Somehow that got added. Thanks for the catch. As far as INT > for student id goes, I'm using email because it will be unique, and offers > an e

Re: Fun with Dates and Incentives.

On Wednesday 24 May 2006 15:18, Brian Menke scribble on about: > Peter, thanks for the detailed info. I will figure out how to get rid of > the UNIQUE key. Somehow that got added. Thanks for the catch. As far as INT > for student id goes, I'm using email because it will be unique, and offers > an e

Re: Need Update Query Help (Urgent)

ot; Currently, you cannot update a table and select from the same table in a subquery." <http://dev.mysql.com/doc/refman/5.0/en/update.html> However, you can to something like: select @maximum_column :=max(col_1) from table_1; UPDATE table_1 SET col_3 = 'bbb' WHERE col_1 = @m

Re: confirm unsubscribe to mysql@lists.mysql.com

m ?192.168.1.47? ( [71.102.133.117]) > by mx.gmail.com with ESMTP id j7sm287121nzd.2005.09.15.10.03.36; > Thu, 15 Sep 2005 10:03:37 -0700 (PDT) > Reply-To: [EMAIL PROTECTED] > Organization: Nensha > To: [EMAIL PROTECTED] > Date: Thu, 15 Sep 2005 10:03:07 -0700 >

Re: MySQLDUMP Problem

se extended inserts are on by default in 4.1.x. To get multiple inserts (usually slower) use a command like: mysqldump --skip-extended-insert mydatabase > mydatabase.sql -- Jeff Shapiro listserv only address -- MySQL General Mailing List For list archives: http://lists.mysql.com/

RE: I need the opposite of BINARY

KE '12SomeString' >> >> As explained in the manual this is treated as a BINARY comparison i.e. >> case of the letters matter. I need a case independent comparison here. Is >> there a way to get the usual behaviour of LIKE in this case? (besides >> trans

Re: Creating Triggers and procedures in MySQL

cility, unless MySQL doesnot > actually have > these important database features. > > Any help is appreciated. > > Gregory Hicks > Database Analyst Programmer --- Listserv only address. Jeff Shapiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: case sensitive?

x27;; > > The first 2 queries are faster. They result are all the same. > > However, if I want to retrieve only 'sandy' instead of 'Sandy'. Is there any > query to achieve that? > > Is there anyway to configure mysql to be case sensitive? > > Thanks! > > Hsiu-Hui --- Listserv only address. Jeff Shapiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: NewbieALERT - Question/problem

> Thanks, > -Ryan > > > > We will slaughter you all! - The Iraqi (Dis)information ministers site > http://MrSahaf.com --- Listserv only address. Jeff Shapiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: What is a good benchmark?

rection? > > Mike > > > mysql> select BENCHMARK(100,ENCODE("hello","goodbye")); > +--+ > | BENCHMARK(100,ENCODE("hello","goodbye")) | > +--+ > |

Re: Q: LOAD DATA command error

ommand is not allowed with this MySQL version" --- Listserv only address. Jeff Shapiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Syntax question

following: set-variable = ft_min_word_len=3 And restart the MySQL server. > > MYSQL version 4.0.12 > > Thanks for your help. > > Ryan > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://l

Re: Two Table Query

#x27; > 2 Lee Ramsey Active > > and for 2001/2/1 and 'Active' > 1 Greg Lindstrom Active > 3 Don TackettActive > > and 2001/2/1 'Retired' > 2 Lee Ramsey Retired > > This would be possible to do in an external Python method (I'm >

Re: establishing a relationship

y a good idea when it > comes to deleting or updating records. (?) > > My question is, how is the relationship between table1 and table2 > established using this method? > > I hope you understand my question. If I try to explain further it > will only become convoluted, possibly

Re: Copy Struct and Data

e (export) in the web ? > The my host in the web work with phpMySQL. > tks, > Celso > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] --- Listserv only address. Jeff Shapir

Re: Advice on improving our current method

[EMAIL PROTECTED] >> -- It's always darkest before the dawn. So if you are going to >> steal the neighbor's newspaper, that's the time to do it. >> (53kr33t w0rdz: sql table query) >> >> >>

Re: Advice on improving our current method

t Number' of all the ones below it, i.e. changing the old > number 1 to a number 2, > number 2 to a number 3, number 4 to a number 5 etc. > > Ideally we need to keep using mysqlcc because it is very simple to > use, but it is very time consuming. > > Any suggestions? > > --- Listserv only address. Jeff Shapiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Using varchar or something else?

/local/mysql/manual.html or where ever you install location is. Or at: http://www.mysql.com/doc/en/Column_types.html --- Listserv only address. Jeff Shapiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: database newbie

know, or think I do, that MySQL > does NOT have/handle Foreign Keys. So what do I do? > > Thanks Ted > > --- Listserv only address. Jeff Shapiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Multiple lookups for one item in one description table

appreciated. > > Example of existing system: > > Table item > > item_id - 1 > item_desc - car1 > > Table item_TO_options > - > item_id > option_id > > Data for Table item_TO_options > -------

RE: computed columns

CAT(fName, ' ', lName) as FullName, > (TO_DAYS(eDat) - TO_DAYS(sDat) + 1) as DaysDuration > FROM mytable; --- Listserv only address. Jeff Shapiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: computed columns

e columns. You can do what you want on retrieval (or for that matter on INSERTion) with: SELECT CONCAT(fName, ' ', lName) as FullName, (TO_DAYS(eDat) - TO_DAYS(sDat) + 1) as DaysDuration FROM mytable; But, then you probably already knew that. --- Listserv only address. Jeff

Re: cannot connect to mysql server

uld be the user that you set up to own the msql directories. I have just switched to a Mac and am unfamiliar with many aspects of unix. I read something about creating a symbolic link but am unsure how to do this and if this will solve the problem. Any help would be greatly appreciated. Peter

Re: Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

//lists.mysql.com/mysql";>http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]">http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EM

RE: select help

nt | 255 | no-pay contact CSRs | +---+-+-+-+ 2 rows in set (0.01 sec) -- Jeff Shapiro | Starlight Spectacular Ride Webmaster| June 21st,2003 at midnight www.starlightspectacular.org | Benefiting the Trails & Op

Re: get the table name from a field for 3 different tables

jeff -- _ ____ +--+ / | / /__ _/ /_ ____ _|Jeff Shapiro | / |/ / _ \/ __ \/ ___/ __ \/ __ `/|Photography and Graphic Design| / /| / __/ / / (__ ) / / / /_/ / |Colorado Springs, CO

Re: Formatting timestamp in MySQL outfile

list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jeff Shapiro, Colorado Springs, CO, USA At work I *have* to use a Windows machine, at home I *get* to use a Mac. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: PHP before mysql on a mac?

lists.mysql.com/[EMAIL PROTECTED] -- Jeff Shapiro, Colorado Springs, CO, USA At work I *have* to use a Windows machine, at home I *get* to use a Mac. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Foreign Key

how to slove this problem. - Email Enviado utilizando o serviço MegaMail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jeff Shapiro, Colorado Springs, CO, USA At work I *have* to

RE: Using LIKE to search for occurence of a column value in a string

t: 'http://www.microsoft.com/kb/' Microsoft Knowledgebase Hi! How about the following? SELECT URL, Name FROM websites WHERE 'http://www.microsoft.com/kb/knowledgeb.asp?id=3&strse=12' LIKE CONCAT(URL, '%'); - Ville -- _ ____ +

Re: Mysqld problem

g List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jeff Shapiro, Colorado Springs, CO, USA At work I *have* to use a Windows machine, at home I *get* to use a Mac. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: upgrading mysql

L PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Jeff Shapiro, Colorado Springs, CO, USA At work I *have* to use a Windows machine, at home I *get* to use a Mac. - Before posting, please check: http

Re: appending to longtext field

with the new note. Depending on what type of system you are creating, doing this "update" method may bring in all kinds of headaches down the road. You may get people trying to change information that some one else put in the tables. The best way to go is the parent/child relationship.

Re: Help with Query

- 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]>

Re: Help with Query

mailing, and 20,000 members that have been sent 2 mailings. Is this possible in one query? TIA, Daren -- _ ____ +--+ / | / /__ _/ /_ _|Jeff Shapiro

Re: Help Exporting Tables/Data

nual.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 -- Jeff Shapiro, Colorado Springs, CO, USA

Re: Remove "-"?

://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 -- Jeff Shapiro, Colorado S

Re: Selecting from mySql database regarding dates

--- 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 unsubsc

Re: Scripting MySQL Commands

ase 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: # of Business Days?

long to us" -- _ ____ +--+ / | / /__ _____/ /_ _|Jeff Shapiro | / |/ / _ \/ __ \/ ___/ __ \/ __ `/|Photography and Graphic Design| / /| / __/ / / (__ ) / / / /_/ / |Colorado S

Re: Help to install Mysql on Macos X 10.2

ts.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 -- Jeff Shapiro, Colorado Springs, CO, USA At work I *hav