I'm sorry, my mistake. The type definition is
*nloc_num,ins_numero and ins_digi are decimal(5,0)
2005/10/11, Luciano Centeno [EMAIL PROTECTED]:
hello, my friends, the query option 1 return the right value,
the query option 2 not. Why concat function make the difference?
*nloc_num,ins_numero
hello, my friends, the query option 1 return the right value,
the query option 2 not. Why concat function make the difference?
*nloc_num,ins_numero and ins_digi are decimal(3,0)
/
option 1 .-
select max(bi_num) as num
from b_inmuebles
,
the query option 2 not. Why concat function make the difference?
*nloc_num,ins_numero and ins_digi are decimal(3,0)
/
option 1 .-
select max(bi_num) as num
from b_inmuebles
where concat(nloc_num) =3D 1
resuming all above i can say that to my greatest regret nobody even
expects what the matter is :(
so i'll just try to install a newer version of server hoping the bug
will disappear
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
PS
after mysql reinstallation (upgrade from 4.1.12 to 4.1.13) from source
code with EXACTLY THE SAME ./configure options as before and the SAME
configuration file everything is OK
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello Averyanov,
[EMAIL PROTECTED] wrote:
Hello Nuno,
Tuesday, July 26, 2005, 8:53:33 PM, you wrote:
[EMAIL PROTECTED] wrote:
(...)
When i try to execute the following query
(...)
i get this error:
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Hello Nuno,
Tuesday, July 26, 2005, 8:53:33 PM, you wrote:
[EMAIL PROTECTED] wrote:
(...)
When i try to execute the following query
(...)
i get this error:
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:6
Current database: test
i've got a strange problem with concat() function
i have the following data structure:
CREATE TABLE table1 (
field1 int(11) NOT NULL auto_increment,
PRIMARY KEY (field1)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3;
CREATE TABLE table2 (
field2 varchar(255) NOT NULL default
[EMAIL PROTECTED] wrote:
i've got a strange problem with concat() function
i have the following data structure:
CREATE TABLE table1 (
field1 int(11) NOT NULL auto_increment,
PRIMARY KEY (field1)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3;
CREATE TABLE table2 (
field2
[EMAIL PROTECTED] wrote:
(...)
When i try to execute the following query
(...)
i get this error:
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:6
Current database: test
ERROR 2013 (HY000): Lost connection to MySQL server during query
Hello mysql,
i've got a strange problem with concat() function
i have the following data structure:
CREATE TABLE table1 (
field1 int(11) NOT NULL auto_increment,
PRIMARY KEY (field1)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3;
CREATE TABLE table2 (
field2 varchar
11 matches
Mail list logo