Re: ERROR 1169: Can't write, because of unique constraint, to table '#sql3aa_a_1'

[Johan Hallenberg - LUB NetLab]

Hello,
I'm experience the same problem. I use a query like this:

SELECT publ,fak,id,COUNT(*) FROM ftxt_stat WHERE year LIKE '2001' AND
month LIKE 'Oct' GROUP BY publ,fak,id;

If I remove COUNT(*) I don't get the error.

The table  I use look like this:

CREATE TABLE ftxt_stat (
  year      VARCHAR(255),
  month     VARCHAR(255),
  fak       VARCHAR(255),
  id        VARCHAR(255),
  publ      VARCHAR(255),
);






---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php