Re: MySQL only listens on localhost

Check for bind-address in your my.cnf file - Franz Edler [EMAIL PROTECTED] escribió: Hello, Can anyone please give me a hint what I can do that MySQL also listens to the physical address of the host. I see that MySQL listen only to 127.0.0.1:3306 and therefore every connection via the

Re: Trigger

Mostly because use 2 field to represent the same data is a waste of storage i think. - Martijn Tonies [EMAIL PROTECTED] escribió: The aplication which is writing to the database is sending the date in unix format. I can't no change that, so i suposse using a triger will help. The

Re: Trigger

The aplication which is writing to the database is sending the date in unix format. I can't no change that, so i suposse using a triger will help. The application pass the 'xx.xx' value when is inserting to the table. - Martijn Tonies [EMAIL PROTECTED] escribió: If i define that the

Re: Trigger

Martijn, If i define that the value for the field must be varchar data type, `fecha` varchar(25) default NULL, the triger records the right date. I think because is wrinting a string only. But if i define the field as a date data type, `fecha` date default NULL, the value writen is: 1969-31-12.

Trigger

Hi, I have a problem with a trigger which should conver a unix timestamp to a MySQL date datatype. The trigger works if the column is varchar, but when the column is date type, it write the date of 1969-31-12. Any ideas? DROP TABLE IF EXISTS `visitas`; CREATE TABLE `visitas` ( `id`

Re: Trigger

(or table names or any other user object)... the example that pops out at me is your field 'Date', which, not surprisingly, is a keyword. this can only lead to greif sooner or later. - michael dykman On 10/11/07, Patricio A. Bruna [EMAIL PROTECTED] wrote: Hi, I have a problem

Upgrade from 4.0 to 4.1 Character problems

Hi, We've recently upgrade from MySQL 4.0.18 to 4.1.20 and our applications (Websphere) its not displaying the character as its supposed to do. But when i do a select... from comand , the results from the old server and the new are the same, also for mysql-query-browser. Thanks

Problem with compex query

Friends, im having troubles with the following query: --- INSERT drp_volumen_venta_diaria_deposito (drp_id_sku, drp_id_deposito, drp_volumen, drp_es_cct, drp_dia, drp_mes, drp_anno, drp_fecha_dia_cargado ) SELECT DISTINCT s.drp_id_sku,

Re: Problem with compex query

; SET SESSION SQL_MAX_JOIN_SIZE=DEFAULT; Run the query; 2) Send your results and explain of query ( explain select ) Regards, Juan On 5/22/07, Patricio A. Bruna [EMAIL PROTECTED] wrote: Friends, im having troubles with the following query

Re: Problem with compex query

Juan Eduardo, 1) The versions are the same. 2) What you meant with indexes for the query? 3) Im goint to try that. 4) Good Idea. Thanks. - Mensaje Original - De: Juan Eduardo Moreno [EMAIL PROTECTED] Para: Patricio A. Bruna [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Enviados