Hi thanks for answer,
maybe it would be good to have a sum_null() function to deal with my case ?
because logically speaking, when a value is null in an operation the result
is null, this is the case for normal functions in mysql (ie not "group by"
function)
i think it is perfect sense that cou
- Original Message -
From: pascal barbedor
To: [EMAIL PROTECTED]
Sent: Sunday, March 31, 2002 6:19 AM
Subject: sum() autoconvert null to zero
Egor,
>Null is an unidentified value, but MySQL will store 0 or ''. You can read
about
>it at:
> http://www.mysql.com/doc
my database or
does it mean mysql would convert it dynamically when sending something to a client ?
has anyone got the same problem ?
looked in the docs, but not a word on utf-8.
thanks
pascal barbedor
hello,
I have installed mysql 3.23.38 binaries on win 98
first mysqld --version says "mysqld-max debug" and not mysqld without
additionnal database systems.
mysqld-max corresponds to mysqld-max ok
I have innodb_* set in my.ini file innodb_dazta_file_path=ibevolif:1M
when trying to start the
I would like to know if a create and drop grants apply with no difference for all
types of tables (heap for instance) and for temporary tables, just like for ordinary
tables.
if yes, isn't it a sort of limitation, because some complicated queries may require
intermediate create and drops some
