Is this a valid Update Query

Hi All, Is this a valid query and will it achieve the result of appending a carriage return and some text to the current contents of a "text" type field: Update Atable set Afield = concat(Afield, "\n", "Some Text") where KeyField = 'keydata' Thanks in advance. Allen -- MySQL General

RE: problem importing .csv (excel format) into mysql

try: lines terminated by '\r\n'; > -Original Message- > From: Chip Wiegand [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 08, 2004 3:36 PM > To: [EMAIL PROTECTED] > Subject: problem importing .csv (excel format) into mysql > > > I was sent an excel file from a remote office, and need

RE: Importing Fixed Length Text Files

Thanks for the response, it was timely and right on the money. Allen -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 6:22 PM To: Allen Weeks; MySQL List Subject: Re: Importing Fixed Length Text Files Allen Weeks wrote: Hello All

Importing Fixed Length Text Files

Hello All, Maybe I am not searching the documentation correctly or am I correct in finding there is not method of directing importing a fixed length text file into a MySQL table? I hope I just missed the reference. Could someone point me to it. Any assistance is greatly appreciated. Allen

Test Message

Hi All, Please pardon the test as I have received no messages from the list in a few days Allen

MySQL 4.1 Production Release

Hi All, Just a quick question, does anyone have a good estimate of when ver 4.1 will go production. Thanks Allen

mysqld-nt vs. mysql-max-nt

Hi All, I can't seem to find any documentation or opinions that would help me decide if it is better to run mysqld-max-nt over the non-max server. Opinions and pointers to supporting docs would be very welcome (especially pointer to docs). Thanks to All in advance. Allen

RE: Round Question

Hi, I tried: Select ceiling(1.2) It worked and returned "2". HTH Allen > -Original Message- > From: Dan Greene [mailto:[EMAIL PROTECTED] > Sent: Friday, September 05, 2003 12:12 PM > To: Fabio Bernardo; Mysql (E-mail) > Subject: RE: Round Question > > > > what I've done is

RE: simple query

Try "SELECT * FROM `phrases` WHERE ph like "%who%"; The percent symbol is the wildcard character for mysql queries HTH > -Original Message- > From: Pag [mailto:[EMAIL PROTECTED] > Sent: Monday, August 25, 2003 11:08 AM > To: [EMAIL PROTECTED] > Subject: simple query > > > > >

RE: Slow results with simple, well-indexed query

The only thing I can add is check you hardware and OS platform. Cheers -Original Message- From: Jesse Sheidlower [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 11:44 AM To: Cybot Cc: [EMAIL PROTECTED] Subject: Re: Slow results with simple, well-indexed query On Thu, Aug 21,

RE: Simple error ... Im sure

If you are using a MySQL version allowing subselects, try this: SELECT * FROM temp_hits WHERE url NOT IN(SELECT * FROM hits) use parenthesis not brackets hope it helps Allen -Original Message- From: news [mailto:[EMAIL PROTECTED] Behalf Of Soren O'Neill Sent: Tuesday, August 19, 2003 2