On 27 May 2002, at 22:32, [EMAIL PROTECTED] wrote:
> mysql> SELECT dd,count(*) FROM test GROUP BY dd;
> +--+--+
> | dd | count(*) |
> +--+--+
> | 20020527 |1 |
> | 20020527 |1 |
> | 20020527 |1 |
> | 20020527 |1 |
> +--
sitnikov,
Monday, May 27, 2002, 10:32:07 PM, you wrote:
s> Description:
s> Problem with timestamp(8) and GROUP BY
s> How-To-Repeat:
mysql>> CREATE TABLE test (
s> -> id int auto_increment,
s> -> dd timestamp(8),
s> -> data int,
s> -> PRIMARY KEY (id)
s> -> );
s> Quer
try timestamp(14) instead.
[EMAIL PROTECTED] wrote:
>Description:
> Problem with timestamp(8) and GROUP BY
>
>How-To-Repeat:
>
>mysql> CREATE TABLE test (
>-> id int auto_increment,
>-> dd timestamp(8),
>-> data int,
>-> PRIMARY KEY (id)
>-> );
>Query OK, 0 rows affecte
Description:
Problem with timestamp(8) and GROUP BY
How-To-Repeat:
mysql> CREATE TABLE test (
-> id int auto_increment,
-> dd timestamp(8),
-> data int,
-> PRIMARY KEY (id)
-> );
Query OK, 0 rows affected (0.01 sec)
mysql> INSERT INTO test (data) VALUES(1),(2),(3),(4