Le mardi 24 janvier 2006 à 09:19 +0100, Martijn Tonies a écrit :
>> CREATE TABLE `tp_participation` (
>> `uid` int(11) NOT NULL default '0',
>> `challenge_id` int(11) NOT NULL default '0',
>> `response` text collate latin1_general_ci NOT NULL,
>> `points` int(11) default NULL,
>> UNIQUE K
that
> you aren't inadvertently writing the query incorrectly and that you really
> DO have 10 rows with cid = 123. If you still get 2 as the result of your
> query, I would recommend sending a bug report to MySQL.
>
> Rhino
>
> - Original Message -
> Fro
gt; combinations that do not contain NULL by giving a list of
> expressions. In standard SQL, you would have to do a
> concatenation of all expressions inside COUNT(DISTINCT ...).
>
> COUNT(DISTINCT ...) was added in MySQL 3.23.2.
>
> Keith
>
> In theory, theory and pr
Hi,
I'm facing a strange problem. I am using a database at my Internet
provider (Free, France). The type of table is MyISAM (no choice), MySQL
4.1.15. I can do my tests with my PHP code or phpMyAdmin.
The definition of my table is:
- uid, int
- cid, int
- response, text
- points, int (can be null
