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
eturn 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
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
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:http://lists.mysql
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:http://lists.mys
>> 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 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...
Co
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 CHARSE
[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
bu
[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 (
f
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 de
11 matches
Mail list logo
