5.0.37 for Mac OS X 10.4 64 bit

Dear MySQL'ers, Any chance that MySQL for OS X 10.4 64 bit will be updated to 5.0.37? It's still at 5.0.27. Thanks, Jan Pieter Kunst -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

view problem

Hello, I'm having some problems with views. Could please someone give me some help? I created two tables and a view. I created the view using WITH CASCADED CHECK OPTION because I need to update some columns of the view. When I do update 2007_marche set data_invio_teramo = current_date where

./mysql/proc' is marked as crashed and should be repaired

Hi Friends, I am getting ./mysql/proc' is marked as crashed and should be repaired on dev db, please let me know, how can i fix this. This is not allowing any action on stored procs. regards anandkl

Re: ./mysql/proc' is marked as crashed and should be repaired

Hi All, We fixed it using mysqlcheck --repair mysql proc -u root -pxxx On 4/5/07, Ananda Kumar [EMAIL PROTECTED] wrote: Hi Friends, I am getting ./mysql/proc' is marked as crashed and should be repaired on dev db, please let me know, how can i fix this. This is not allowing any action on

RE: Problem with authentication

have a look on this: http://dev.mysql.com/doc/refman/5.0/en/old-client.html it is because your php is using old mysql libraries, upgrade your php or consult that page... Regards! -Original Message- From: John Meyer [mailto:[EMAIL PROTECTED] Sent: Miércoles, 04 de Abril de 2007

RE: 5.0.37 ,sql a table still not found

in mysql doc you could find a better answer of your problem (http://dev.mysql.com/doc/refman/5.0/en/join.html) have a look on the part Join Processing Changes in MySQL 5.0.12 but that you have to do is use implicit joins: select * from a1 inner join a2 on a1.f2=a2.f2 left

MySQL slave error when creating view

I ran the following DDL on our master today: CREATE OR REPLACE VIEW REF_TRANSFER_PREFERENCE ( IORG_UID, TDISTRICT_NAME, IORGDISPLAY, IORG ) AS SELECT 0, TDISTRICT_NAME, IORG_UID, IORG_UID FROM REF_PREFERENCE ; The master happily created the view. The slave however dies with:

append information

I have a question if you don't mind. The update statement will replace the existing information. What if I have Textarea instead and I want to add information to the field without erasing previous information. Basically append information -

re: append information

Use the CONCAT() function to achieve this: UPDATE tmpTable SET Textarea = concat(Textarea,'data you wish to add') WHERE ID = someID HTH! From: sam rumaizan [EMAIL PROTECTED] Sent: Thursday, April 05,

return integer for positive values

I have a table with a list of pollutants. I have a table of locations, site names, counties, etc. I can join the these tables together and get a list of of all the pollutants at a site. But, what I am really wanting is a list of all the pollutants with a integer field, zero for pollutant

RE: return integer for positive values

I'm not sure I quite follow. Is there a concentration for each location for each of a master list of pollutants? What concentration would be considered not there? In any case, look at a construct like (ABS(concentration) = tolerance), where tolerance can be either a constant or a field associated

RE: return integer for positive values

I am at a higher level than that. Here is my query: SELECT distinct emt.group_name FROM epa.aq_ambient_nad83 aq_, epa.aq_ambient_pollutants pol, epa.emtb_pollutant_group emt, epa.pollutant pt WHERE (aq_.siteid = pol.siteid) AND (emt.group_code = pt.ambient_group_code) AND

Re: return integer for positive values

[EMAIL PROTECTED] wrote on 04/05/2007 02:46:43 PM: I have a table with a list of pollutants. I have a table of locations, site names, counties, etc. I can join the these tables together and get a list of of all the pollutants at a site. But, what I am really wanting is a list of all

RE: return integer for positive values

Are you trying to get a 1 or 0 depending upon whether or not there is an AQ_ record that matches? If so, then you could use a LEFT JOIN and an IF(ISNULL(AQ_.SITEID),0,1) or something like that. I probably don't understand your query. Regards, Jerry Schwartz Global Information Incorporated 195

[Q] encoding cast

Hello there, I have the following problem, I open a terminal on the mysql server with set names utf8. I have the following string: _latin1φου (this is a greek word), how can i get back the utf sting? I tried various combinations using convert and cast but i can't get it to work.. e.x.

Poor performance with WHERE Value like 'XXX%'

Hi Folks, I'm getting some unexpectedly poor performance from some queries using the like operator. The table is an Innodb table with an index on the column appearing in a like conditional. Explain gives me this: [localhost]explain select PRODUCT_ID from My_Table where PRODUCT_ID like

Re: Poor performance with WHERE Value like 'XXX%'

Rod, I'm speculating here, but I think what's happening is that too many of your entries have a PRODUCT_ID that starts with 'DRM' to make your index useful. When MySQL expects an index query to match more than around 30% of all rows, it will instead proceed with a table scan, estimating that to

Privileges question.

Hi all, I am trying to create a user with only SELECT,INSERT,UPDATE,DELETE privileges on a database. My question is when I type show grants for the user I create, it says the user has full privileges over the database and I only want them to have the ones listed above. mysql grant

RE: Privileges question.

Nevermind, I had a lingering entry in the db table. Once I deleted that it worked as expected. Denise Lopez UCLA Center for Digital Humanities Network Services Systems Engineer 337 Charles E. Young Drive East PPB 1020 Los Angeles, CA 90095 310/206-8216 -Original Message- From: Lopez,

test - please ignore

Replication among disconnected Servers

Hi All, We have a MySQL 5.0 server (master) running on Windows. For backup, I wish to setup another system with same version of MySQL to act as backup / slave. But this slave can not have direct access to the master. Is there a way I can achive this? I do not wish to take a full dump in